Why PivotTables summarize data fast in Google Sheets - Formula Trace Breakdown

Sample Data

Sales data for products by region

Cell	Value
A1	Product
B1	Region
C1	Sales
A2	Apples
B2	North
C2	100
A3	Apples
B3	South
C3	150
A4	Oranges
B4	North
C4	200
A5	Oranges
B5	South
C5	120

Formula Trace

=SUMIF(A2:A5, "Apples", C2:C5)

Step 1: A2:A5 = {"Apples", "Apples", "Oranges", "Oranges"}

Step 2: Condition: check which cells equal "Apples"

Step 3: C2:C5 = {100, 150, 200, 120}

Step 4: Sum values where condition is TRUE: 100 + 150

Cell Reference Map

    A       B       C
1 Product  Region  Sales
2 Apples   North   100
3 Apples   South   150
4 Oranges  North   200
5 Oranges  South   120

Formula references:
- A2:A5 for product names
- C2:C5 for sales values

The formula uses product names in A2:A5 and sales in C2:C5 to sum sales for Apples.

Result

    A       B       C       D
1 Product  Region  Sales   Sum of Apples
2 Apples   North   100     250
3 Apples   South   150
4 Oranges  North   200
5 Oranges  South   120

The formula result 250 appears in D2, showing total sales for Apples quickly.

Sheet Trace Quiz - 3 Questions

What does the formula =SUMIF(A2:A5, "Apples", C2:C5) do?

A Adds sales values only for Apples

B Adds all sales values

C Counts how many Apples are sold

D Finds the highest sales value

Key Result

SUMIF sums values in one range based on matching criteria in another range.