Forum Discussion
Solved
Simpler logical test syntax for criteria against multiple values
I'm desperately looking for a leaner formula for =IF(A1=any of {value A,value B,value C, etc},TRUE,FALSE) with resorting to the classic use OR =IF(OR(A1=value A,A1=value B,A1=value C,etc),TRUE,FALSE)...
=SUM(SUMIF(criteria_range, {"apples", "oranges"}, sum_range))
=SUM(SUMIF(criteria_range, C2:C8, sum_range))
=SUM(SUMIF(criteria_range, {"apples", "oranges"}, sum_range))
=SUM(SUMIF(criteria_range, C2:C8, sum_range))
Thank you very much Hans. Sorry it takes a while. I will revert after exploring what your sleek suggestion covers and what still need to be sleekified!