Sumif greater than or equal not working

**cartica** · 05-04-2016, 06:28 PM

HI,

I am trying to do a sumif, but get an error that i am making too many arguments.

Please Login or Register  to view this content.

I am looking at the column e2:e17, and want to sum up anything in that column that is equal to or between 750-1500.

Thanks

**jjhayes** · 05-04-2016, 06:39 PM

Try:

Please Login or Register  to view this content.

Sumif wont work with more than one criteria I think...

**Tony Valko** · 05-04-2016, 06:41 PM

Use SUMIFS for multiple criteria:

=SUMIFS(E2:E17,E2:E17,">=750",E2:E17,"<=1500")

**Crooza** · 05-04-2016, 06:42 PM

Sumif only works on one criteria

You'll need sumifs

=SUMIFS(e2:e17,e2:e17,">=750",e2:e17,"<=1500")

**Tony Valko** · 05-04-2016, 06:48 PM

Here's how you could do it with SUMIF:

=SUMIF(E2:E17,">=750")-SUMIF(E2:E17,">1500")

Re: Sumif greater than or equal not working