Thread
:
Formula too long
View Single Post
#
3
Posted to microsoft.public.excel.programming
JulieD
external usenet poster
Posts: 618
Formula too long
Hi
i'm concerned about the
$A$1:$V$5000="Apples"
bit ... is this just a typo?
Cheers
JulieD
"Don Guillett" wrote in message
...
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
Reply With Quote
JulieD
View Public Profile
Find all posts by JulieD