try
=SUMPRODUCT(($A$1:$V$5000="Apples")*($B$1:$B$5000= ({"Good","Very
Good","Bad"}))
but it might be better to use < "Really Bad" instead

--
Don Guillett
SalesAid Software

"Paul" wrote in message
...
Hi,

Newbie. I'm trying to count with mutliple criterias (I'm
only showing 3...but I have 35 critearias...Below is my
formula...when I put all of my criterias...i have
a "Formula too long" message...Please help...I dont want
Pivot table because I want dynamic data...Thanks.

Paul

=SUMPRODUCT(($A$1:$V$5000="Apples")*(($B$1:$B$5000 ="Good")+
($B$1:$B$5000="Very Good")+ ($B$1:$B$5000="Bad")))

Should give me 3 as a results



A B

Apples Good
Apples Very good
Oranges Good
Oranges Very good
Oranges Very good
Apples Super
Apples Bad