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. ???
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.