| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula too long
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 |
| 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) | |||
| Long formula | Excel Worksheet Functions | |||
| formula too long | Excel Worksheet Functions | |||
Threaded Mode
