0
0
Google Sheetsspreadsheet~10 mins

Value aggregation (SUM, COUNT, AVG) in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows sales amounts in cells A2 to A5. We want to calculate the total sales, count of sales entries, and average sales.

CellValue
A1Sales
A2100
A3200
A4150
A550
A6Total
B1Count
B64
C1Average
C6125
Formula Trace
=SUM(A2:A5)
Step 1: A2:A5
Step 2: SUM(100, 200, 150, 50)
Cell Reference Map
    A    B    C
1 |Sales|Count|Average
2 | 100 |     |      
3 | 200 |     |      
4 | 150 |     |      
5 |  50 |     |      
6 |Total|  4  | 125
The formula references cells A2 to A5 which contain the sales values to sum.
Result
    A    B    C
1 |Sales|Count|Average
2 | 100 |     |      
3 | 200 |     |      
4 | 150 |     |      
5 |  50 |     |      
6 | 500 |  4  | 125
The sum of sales values (100 + 200 + 150 + 50) is 500, shown in cell A6. The count of sales entries is 4 in B6, and the average sales is 125 in C6.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula =SUM(A2:A5) calculate?
AThe total of all sales values in A2 to A5
BThe number of sales entries in A2 to A5
CThe average of sales values in A2 to A5
DThe highest sales value in A2 to A5
Key Result
SUM(range) adds all numbers in the specified range to get a total.