=SUMPRODUCT(--(C2:C200100),SIGN((A2:A200="X")+(B2:B200="Y")))


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"CDPalmer" wrote in message
...
I wish to count text in a column (say column C) such that (A or B) and C
are
satisfied.
Can someone help please.
Thanks
--
CDP