Expanding a Sumproduct array

[hatstand]

If I use the formula below it will look into column A for “Fax” and column C that equals 20.

=SUMPRODUCT(--(A2:A10="Fax"),--(C2:C10=20))


But, is there a way to expand C2:C20 to C2:E20 and there for look for all occurrences of 20 with the row that has Fax in column A.

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER...

=SUM(IF(A2:A20="Fax",IF(C2:E20=20,1)))

Hope this helps!

xl-central.com

 

[hatstand]

That's perfect. I've been trying to figure that out for hours. Thanks very much.