The text cell is retyped as the number 760 and the pivot is refreshed, so Values returns to Sum of amount. The ON orders are 420, 760, 510 and 305. What does the ON row show? (Whole number.)
The text cell is retyped as the number 760 and the pivot is refreshed, so Values returns to Sum of amount. The ON orders are 420, 760, 510 and 305. What does the ON row show? (Whole number.)
Answer
1995
Cells - Sum of amount, ON · ±0 420 + 760 + 510 + 305 = 1995 — the pivot cell, `=SUMIF(B2:B13, "ON", D2:D13)`, and aggregate(amount ~ prov, orders, sum) all agree. Before the fix a Sum would have shown 1235.