Ouch!! & thanks!

Your SUMPRODUCT() handles that case correctly.

This is why, whenever I face complicated criteria, I run away and hide
behind a helper column.
--
Gary''s Student - gsnu200813


"ShaneDevenshire" wrote:

Hi Gary,

Your formula will double count if row 2 has F17000 in columns B and C.


--
Thanks,
Shane Devenshire


"Gary''s Student" wrote:

=SUMPRODUCT((B1:B100="F17000")*(A1:A100="Out of
Warranty"))+SUMPRODUCT((C1:C100="F17000")*(A1:A100 ="Out of Warranty"))

--
Gary''s Student - gsnu200813