Excel
=SUBTOTAL(...)SUBTOTAL vs AGGREGATE: Sum Only Visible Rows in Excel
Use SUBTOTAL and AGGREGATE in Excel to sum only visible rows. Compare codes 9 vs 109 to skip hidden rows and errors.
Explore ↗
#subtotal
1 formula guide
1 formula guide
=SUBTOTAL(...)Use SUBTOTAL and AGGREGATE in Excel to sum only visible rows. Compare codes 9 vs 109 to skip hidden rows and errors.