Excel formula for the sum of only what is filtered?

[tony_lutesTLCC]

I have column filters on my mathematical data. Need a formula that sums only the filtered data.

???

[#2]

@tony_lutesTLCC 

What are the criteria for the filtering? Use those same criteria in a SUMIF or SUMIFS formula. There are probably other ways as well, but that would be where I'd start.

[#3]

@tony_lutesTLCC 

Hi, I hope I can help you.

Considering your data values on column B you can achieve the result by using the following formula

=SUBTOTAL(9;B2:B100)

There are a few arguments for different type of calculation. In your specific case I'm using the number 9 that represents the SUM.

This function is very fun - Explore the other options as well.