Sum of only Filtered cells
How can I get a sum of ONLY the cells that I filtered from a table?
iPad Pro, iPadOS 18
How can I get a sum of ONLY the cells that I filtered from a table?
iPad Pro, iPadOS 18
If you mean you want a sum of only the cells that are showing, look at the SUBTOTAL function. Example:
=SUBTOTAL(109,B2:B20)
If you mean you want a sum of only the cells that are showing, look at the SUBTOTAL function. Example:
=SUBTOTAL(109,B2:B20)
Sum of only Filtered cells