SOLVED

SUMIFS NOT WORKING WITH 2 CRITERIA

Copper Contributor

Hello,

 

I need to sum entries based on 2 criteria. For the sum_range, criteria_range1 and criteria_range2, I've picked up the whole column e.g. A:A, B:B, C:C.

Somehow the result is returning 0. Appreciate if someone here could help me.

 

Thanks!

BusterSG_0-1683469758695.png

 



2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@BusterSG 

 

At a minimum, the second condition should be ">=" & E2 instead of ">=E2".

 

@Joe Usergot it! thank you so much!

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@BusterSG 

 

At a minimum, the second condition should be ">=" & E2 instead of ">=E2".

 

View solution in original post