Microsoft Excel — Medium
Key points
- SUBTOTAL's function number determines its behavior with hidden rows
- SUM includes all cells, regardless of visibility
- The function number in SUBTOTAL affects its calculation
- SUBTOTAL and SUM differ in their handling of filtered data
Ready to go further?
Related questions