Forum Discussion
Excel formula for the sum of only what is filtered?
I have column filters on my mathematical data. Need a formula that sums only the filtered data.
???
2 Replies
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.
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.
