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. Appreciate if someone here could help me.

 

Thanks!

 



Resources