Ravi Sir's Cards › Excel
SUBTOTAL codes and the Table Total Row
Revision card: SUBTOTAL codes and the Table Total Row. Example data table with Average with SUBTOTAL: ₹250; Largest amount: ₹400; Table Total Row with Lamp filtered out: ₹600.
Read card text
What this card says
SUBTOTAL codes and the Table Total Row
Example
data table with Average with SUBTOTAL: ₹250; Largest amount: ₹400; Table Total Row with Lamp filtered out: ₹600
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