May 07 2023 07:30 AM
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!
May 07 2023 07:57 AM
SolutionMay 07 2023 07:57 AM
Solution
At a minimum, the second condition should be ">=" & E2 instead of ">=E2".