| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula too long
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula too long
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
| Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| Formula too long using IF OR | Excel Worksheet Functions | |||
| formula too long | Excel Worksheet Functions | |||
Linear Mode
