Filter Sum

[mdt175]

Greetings - when using a Filter option - using a Sum function still includes cells that did not make the criteria as it only hides cells. Is there a way to Sum only data left after you Filter? Thanks!

[johnmpl]

Hi, @mdt175!

Yes, use the SUBTOTAL function, like:
=SUBTOTAL(9, range) --> If you want to sum all the numbers that you see when you filter, or
=SUBTOTAL(109, range) --> If you want to sum all the numbers that you see when you filter or hide rows.

Blessings!