Hi Dave,

Thank you very much for all your help and taking the time to assist. The
formula is working fine.

=SUMPRODUCT((A1:A4=1)*(B1:B4=2)*(OFFSET(C1:C4,1,0) ="cat"))

Regards,
Sam

--
Message posted via http://www.officekb.com