Hi,

This is a repost...Thanks Don and Julie but solutions did
not work...

I'm trying to count with multiple criterias (I'm
only showing 3...but I have 35 criterias...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:$A$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