Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT with #VALUE error
First, thank you in advance for your help.
Can I use SUMPRODUCT to count the number of occurances of a value when there are errors in the column I want to count? Example is I was trying this formula to count the number of times J.Doe was late but there are #Value errors in column V3:V890. =SUMPRODUCT(--(F3:F890="J.DOE"),--(V3:V890="LATE")) How do I get around this without deleting the formulas in the cells that have the error because it will change when other data gets filled in. Thanks for you help Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT #VALUE! error | Excel Worksheet Functions | |||
SUMPRODUCT #N/A error | Excel Discussion (Misc queries) | |||
Sumproduct value error | Excel Worksheet Functions | |||
Sumproduct error | Excel Worksheet Functions | |||
Sumproduct error | Excel Worksheet Functions |