Just a quick response. Must dash, no time to think or test, but perhaps try
naming the ranges, using a very short range name, such as A_1 refers to
$A$1:$A$5000. Then refer to the names in the formula. This may reduce the
number of characters required in the formula.

"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