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
Highlighted
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)

@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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies