Hi,

Can somebody tell me which of two is better & why.

Counting Based on Multiple Criteria
We can use =SUMPRODUCT((C2:C6<1000)*(B2:B6="red")) or we can also use array formula with Sum(if((C2:C6<1000),if(B2:B6="red")),1,0) (syntax might not be exact).

IS there any advantage of using Sumproduct over using Sum(if, or vice versa.

Please educate, since I have been using the array formula version (sum(if).

Thanks in advance.

Regards
Anand