Question: what is the difference between sum and count in excel?
Answer: Very simply, SUM calculates a total for a number of cells or values, so it's answering the question: HOW MUCH? Or, WHAT IS THE TOTAL? COUNT tells you HOW MANY cells meet a certain condition. Cell A6 uses a SUM function to add up the values in cells A1 to A6.