Excel formula for the sum of only what is filtered?

%3CLINGO-SUB%20id%3D%22lingo-sub-1616932%22%20slang%3D%22en-US%22%3EExcel%20formula%20for%20the%20sum%20of%20only%20what%20is%20filtered%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616932%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20column%20filters%20on%20my%20mathematical%20data.%20Need%20a%20formula%20that%20sums%20only%20the%20filtered%20data.%3C%2FP%3E%3CP%3E%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1616932%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1616945%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20for%20the%20sum%20of%20only%20what%20is%20filtered%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616945%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773604%22%20target%3D%22_blank%22%3E%40tony_lutesTLCC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20are%20the%20criteria%20for%20the%20filtering%3F%20Use%20those%20same%20criteria%20in%20a%20SUMIF%20or%20SUMIFS%20formula.%20There%20are%20probably%20other%20ways%20as%20well%2C%20but%20that%20would%20be%20where%20I'd%20start.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617728%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20for%20the%20sum%20of%20only%20what%20is%20filtered%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617728%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773604%22%20target%3D%22_blank%22%3E%40tony_lutesTLCC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20I%20hope%20I%20can%20help%20you.%3C%2FP%3E%3CP%3EConsidering%20your%20data%20values%20on%20column%20B%20you%20can%20achieve%20the%20result%20by%20using%20the%20following%20formula%3C%2FP%3E%3CP%3E%3DSUBTOTAL(9%3BB2%3AB100)%3C%2FP%3E%3CP%3EThere%20are%20a%20few%20arguments%20for%20different%20type%20of%20calculation.%20In%20your%20specific%20case%20I'm%20using%20the%20number%209%20that%20represents%20the%20SUM.%3C%2FP%3E%3CP%3EThis%20function%20is%20very%20fun%20-%20Explore%20the%20other%20options%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

???

2 Replies

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

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