Ravi Sir's Cards › Excel
SUBTOTAL and AGGREGATE
Revision card: SUBTOTAL and AGGREGATE. Example data table with Total of the visible rows only: ₹700; SUM with the same filter: ₹1,250; Add bonuses that include an error (filter off): ₹175.
Read card text
What this card says
SUBTOTAL and AGGREGATE
Example
data table with Total of the visible rows only: ₹700; SUM with the same filter: ₹1,250; Add bonuses that include an error (filter off): ₹175
Learn this in the lesson: 6. Tables, Sorting and Filtering