Home

Excel query

%3CLINGO-SUB%20id%3D%22lingo-sub-503346%22%20slang%3D%22en-US%22%3EExcel%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503346%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20sum%20column%20G2%3AG50%20but%20only%20if%20the%20amount%20in%20column%20E2%3AE50%20is%20larger%20and%20equal%20to%200.01%20and%20less%20and%20equal%20to%2010%2C000%20what%20formula's%20can%20I%20use%3F%3C%2FP%3E%3CP%3EHope%20this%20is%20clear.%3C%2FP%3E%3CP%3EAny%20help%20will%20be%20appreciated.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-503346%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-503652%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503652%22%20slang%3D%22en-US%22%3EUse%20SUMIFS%20like%20this%3A%3CBR%20%2F%3E%3DSUMIFS(G2%3AG50%2C%3CBR%20%2F%3EE2%3AE50%2C%E2%80%9D%26gt%3B%3D%E2%80%9C%26amp%3B0.01%2C%3CBR%20%2F%3EE2%3AE50%2C%E2%80%9D%26lt%3B%3D%E2%80%9C%26amp%3B10000)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-503973%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3Bthank%20you%2C%20this%20helped%2C%20I%20had%20something%20similar%20but%20didn't%20pay%20attention%20that%20I%20had%20mixed%20up%20the%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Debbieo
New Contributor

Hi, I am trying to sum column G2:G50 but only if the amount in column E2:E50 is larger and equal to 0.01 and less and equal to 10,000 what formula's can I use?

Hope this is clear.

Any help will be appreciated.

Thanks

3 Replies
Use SUMIFS like this:
=SUMIFS(G2:G50,
E2:E50,”>=“&0.01,
E2:E50,”<=“&10000)
Highlighted

@Twifoo thank you, this helped, I had something similar but didn't pay attention that I had mixed up the columns.

I’m glad to have helped you.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies