Posted to microsoft.public.excel.misc
|
|
SUMPRODUCT + ISNUMBER(SEARCH) + Empty Cells
That seemed to work just fine. Thank you very much for you help and time.
--
RyGuy
"Max" wrote:
.. Can I full-proof my calculation to ignore any empty cells it may find?
It's probably due to null strings/text returned/existing within OctEffort
(real blank cells pose no problem)
Try the array-entered SUM(IF(...)) alternative:
=SUM(IF(ISNUMBER(SEARCH({"QA","qual"},(OctEnvironm ent))),OctEffort))
Above tested lightly, works fine
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"BLUV" wrote:
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?
|