SUMIFS Between Two Dates With Exclusion Criteria

[jski21]

Good day Mr. Excel Team,

Can't seem to get this formula to work properly: =SUMIFS(J:J,B:B,">=7",B:B,"<=9","<>INC",M:M).

Logic: Sum the values in Column J if the numbers in Column B are between 7 and 9, but exclude any value in Column J if the value in Column M equals "INC".


Thanks ETeam!


jski

 

[hagia_sofia]

Hello, try:

=SUMIFS(J:J,B:B,">="&7,B:B,"<="&9,M:M,"="&"INC")

 

[Fluff]

Almost there, the last two are the wrong way round

=SUMIFS(J:J,B:B,">=7",B:B,"<=9",M:M,"<>INC")

 

[jski21]

Works well Fluff. Thanks everyone.

 

[Fluff]

Glad we could help & thanks for the feedback.