Forum Discussion

Debbieo's avatar
Debbieo
Copper Contributor
Apr 30, 2019

Excel query

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

Formulas and Functions

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 30, 2019
    Use SUMIFS like this:
    =SUMIFS(G2:G50,
    E2:E50,”>=“&0.01,
    E2:E50,”<=“&10000)
    • Debbieo's avatar
      Debbieo
      Copper Contributor
      Apr 30, 2019

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

Resources