Excel query

[Debbieo]

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

[#2]

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

[#3]

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

[#4]

I’m glad to have helped you.