Hi All,

I am trying to write a formula that counts cells in column B that CONTAIN a value y IF the cells in column A CONTAIN a value X where X and Y are strings of letters. I capitalized CONTAINS because i have writen the following formula that works when the cells EQUAL X and Y but not when they contain:

=SUMPRODUCT(--(A1:A100="X"),--(B1:B100="Y"))


Any ideas on how to get this to work would be greatly appreciated!

Thanks
Keith