Forum Discussion

BusterSG's avatar
BusterSG
Copper Contributor
May 07, 2023
Solved

SUMIFS NOT WORKING WITH 2 CRITERIA

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....
excel
  • JoeUser2004's avatar
    JoeUser2004
    May 07, 2023

    BusterSG 

     

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

     

JoeUser2004's avatar
JoeUser2004
Bronze Contributor
May 07, 2023

BusterSG 

 

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

 

BusterSG's avatar
BusterSG
Copper Contributor
May 07, 2023

JoeUser2004got it! thank you so much!

Resources