CODEWITHSUNDEEP
excelexcel-formulaformula
IIJHFII
IIJHFII

Reputation: 600

SUMIFS, with < or > criteria

May be an easy thing for someone more knowledgable than I, but i'm learning :) I have this formula which aims to sum column N if O is "x" and G is "y" and it works fine: 

=SUMIFS(Data_Sheet!N:N,Data_Sheet!O:O,Summary!$A$6,Data_Sheet!G:G,"INF")

I want to add a third criteria that only sums N if O > 0. I have tried using the same formula syntax but can't get it to work. any ideas on where i'm going wrong?

=SUMIFS(Data_Sheet!N:N,Data_Sheet!O:O,Summary!$A$6,Data_Sheet!G:G,"INF",Data_Sheet!O:O,<0)

Upvotes: 1

Views: 240

Answers (1)

Scott Holtzman
Scott Holtzman

Reputation: 27239

The criteria for < or > or >= or <= needs to be in quotes:

=SUMIFS(Data_Sheet!N:N,Data_Sheet!O:O,Summary!$A$6,Data_Sheet!G:G,"INF",Data_Sheet!O:O,">0")

Note that I changed the sign to > in my answer since your text said >0 where as your formula said <0

Upvotes: 1

Related Questions