Ravi Sir's Cards › Excel
SUM vs SUBTOTAL 9 vs SUBTOTAL 109
Revision card: SUM vs SUBTOTAL 9 vs SUBTOTAL 109. Example data table with SUM with row 3 hidden: ₹1,000; Row 3 hidden by a filter: ₹800; Row 3 hidden by hand instead: ₹800.
Read card text
What this card says
SUM vs SUBTOTAL 9 vs SUBTOTAL 109
Example
data table with SUM with row 3 hidden: ₹1,000; Row 3 hidden by a filter: ₹800; Row 3 hidden by hand instead: ₹800
Learn this in the lesson: SUBTOTAL vs SUM in Excel: Ignore Hidden and Filtered Rows (Function Codes 9 vs 109) and the Table Total Row