| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simplifying/speeding up this formula
Yep, I certainly overlooked that!
"Harlan Grove" wrote: "JMB" wrote... Or you could eliminate the IF statement completely =SUMPRODUCT(('Raw Data'!$A$2:$A$30000=$C5)*1, ('Raw Data'!$B$2:$B$30000=I$1)*1) .... Or eliminate a few unnecessary characters, =SUMPRODUCT(('Raw Data'!$A$2:$A$30000=$C5)*('Raw Data'!$B$2:$B$30000=I$1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplifying a formula | Excel Worksheet Functions | |||
| Simplifying Formula (part 1) | Excel Discussion (Misc queries) | |||
| Simplifying Formula (Part 2) | Excel Discussion (Misc queries) | |||
| Simplifying formula | Excel Discussion (Misc queries) | |||
| Simplifying array formula which evaluates as error. | Excel Worksheet Functions | |||
Hybrid Mode
