Excel Counting and Summing Worksheet Cells

a counting formula returns the number of cells in a specified range that meet certain criteria. A summing formula returns the sum of the values of the cells in a range that meet certain criteria. The range you want counted or summed may or may not consist of a worksheet database.

Lists the Excel worksheet functions that come into play when creating counting and summing formulas. Not all these functions are covered in this tutorial. If none of the functions in list can solve your problem, it's likely that an array formula can come to the rescue.

If your data is in the form of a table, you can use autofiltering to accomplish many counting and summing operations. Just set the autofitler criteria, and the table displays only the rows that match your criteria (the nonqualifying rows in the table are hidden). Then you can select formulas to display counts or sums in the table's total row.