Home

Excel query

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.

Highlighted
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