| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT + ISNUMBER(SEARCH) + Empty Cells
I have the following calculation working for me where OctEffort = I2:I3324
and OctEnvironment = G2:G3324. =SUMPRODUCT(ISNUMBER(SEARCH({"QA","qual"},(OctEnvi ronment)))*OctEffort) This approach requires me to be mindful of empty cells and ensure the I and G columns do not interrogate cells beyond row 3324. If I set OctEffort and OctEnvironment to be I2:I5000 and G2:G5000 respectively, then my calculation fails because of blank/empty cells. Can I full-proof my calculation to ignore any empty cells it may find? -- RyGuy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine: ISNUMBER(SEARCH( and EXACT( ? | Excel Discussion (Misc queries) | |||
| sumproduct including empty cells | Excel Discussion (Misc queries) | |||
| Limit to nested IF(ISNUMBER(SEARCH)) functions? | Excel Worksheet Functions | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| isnumber with sumproduct | Excel Worksheet Functions | |||
Threaded Mode
