The question was
You have 35 conditions out of how many conditions, not rows!
I assume that of the 200 rows that there are many duplicates.

--
Don Guillett
SalesAid Software

"Paul" wrote in message
...
Thanks...I have 35 condition in a row of 200
values...tries searching the web in vain...

Paul
-----Original Message-----
What I sent will work to shorten the formula but maybe
not all of your 35.
You have 35 conditions out of ______how many. Did you see
my suggestion for
using < (not equal to)
=SUMPRODUCT(($A$1:$a$5000="Apples")*
($B$1:$B$5000<"Really Bad"))
or

--
Don Guillett
SalesAid Software

"Paul" wrote in message
...
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



.