Summing (adding values) is an integral part of data analysis, whether you are subtotaling sales in the Northwest region or doing a running total of weekly receipts. Excel provides multiple techniques that you can use to sum data.
To help you make the best choice, this article provides a comprehensive summary of methods, supporting information to help you quickly decide on which technique to use, and links to in-depth articles.
Summing should not be confused with counting. For more information about counting cells, columns, or rows of data, see Count cells, rows, or columns of data.
For addition:
Type: =SUM(starting ID: ending ID)
for count:
Type: =count(starting ID: ending ID)