# The Difference in Sum Vs. Count in Excel

Techwalla may earn compensation through affiliate links in this story.

The "Sum" and "Count" functions in Excel offer two different ways of looking at the numbers in your spreadsheet. If you use both functions to address the same range of cells, each one will return a different result in most cases. Understanding how each function operates requires a basic understanding of a few Excel-based terms.

## Terminology

In Excel, a grouping of several cells is called a "Range." When you enter a formula, such as "Sum" or "Count," you need to specify a range of cells you want the function to calculate. Another common Excel term is "Value." The value is the data you enter into a cell. A value can be numbers, letters or combinations of the two.

Video of the Day

## Sum Function

The "Sum" function in Excel adds together the values of cells within your specified range. For example, a formula of "=SUM(B6:B8)" will add the values contained in cells "B6" through "B8." If you have values such as 6, 7 and 8 in those cells, respectively, your "Sum" formula solution will be 21.