Hi,
why do you use wildcards is because Boo is contained in a text, could you
post what is in column B thanks

"Big UT Fan" wrote:

This doesn't seem to be working...here's what I'm using. Again, I only want
to count the rows where col L CONTAINS "Goat" AND col B DOES NOT CONTAIN
"Boo".

=SUMPRODUCT(('020810'!$B$2:$B$2000<"*Boo*")*('020 810'!$L$2:$L$2000="*Goat*"))

"Eduardo" wrote:

Hi,

=sumproduct(($B$1:$B$1000<"Bear")*($L$1:$L$1000=" Goat"))

if this helps please click yes thanks

"Big UT Fan" wrote:

I need to count the cells in a worksheet where col B doesn't contain a
certain value and col L contains a different value. So...what I need to do
is count the rows where col B doesn't contain "Bear" and col L contains
"Goat". Your help is appreciated.