CONTAINS "Goat" AND col B DOES
NOT CONTAIN "Boo".

What happened to "Bear" ? <g

Looking at your formula:

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

Are you trying to use wildcards? If so, wildcards won't work with
SUMPRODUCT.

So, does that mean the cell might contain more text than just Goat or Boo?
Like:

What a Goat
Boo who

--
Biff
Microsoft Excel MVP


"Big UT Fan" wrote in message
...
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.