Formula too long

[Paul]

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

 

[Don Guillett]

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

 

[JulieD]

Hi

i'm concerned about the
$A$1:$V$5000="Apples"
bit ... is this just a typo?

Cheers
JulieD