Aggregations

The Aggregation Functions

1. Total of a range SUM
   Adds every numeric value in the range. The most commonly used function in any spreadsheet. Ignores empty cells and text.
   =SUM(E3:E35);
2. Mean value AVERAGE
   Calculates the arithmetic mean — the sum divided by the count of numeric values. Ignores empty cells and text, so incomplete rows don't distort the result.
   =AVERAGE(D9:D35);
3. Smallest value MIN
   Returns the lowest number in the range.
   =MIN(D9:D35);
4. Largest value MAX
   Returns the highest number.
   =MAX(D9:D35);
5. Count numeric cells COUNT
   Counts only cells containing a number.
   =COUNT(D9:D35);
6. Count all non-empty cells COUNTA
   Counts every cell that has any content — numbers, text, or formulas.
   =COUNTA(A9:A35).