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

Posted on Feb 11, 2025 2:36 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 11, 2025 5:54 PM

If you mean you want a sum of only the cells that are showing, look at the SUBTOTAL function. Example:

=SUBTOTAL(109,B2:B20)

1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Sum of only Filtered cells

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.