Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF NOT #VALUE Question
I'm trying to SUM a range Q3:Q33, but this range has values in it that get
calculated from other places that will be calculated through time. In the last few cells of the range I have "#VALUE" messages. How do I SUM Q3:Q33 and ignore the #VALUEs? I'm trying =SUMIF(Q3:Q33,"*",Q3:Q33), but this gives me a sum of 0. and =SUMIF(Q3:Q33,"<#VALUE",Q3:Q33), gives me #VALUE. Thanks in advance for your help. --Dax -- I would give my left hand to be ambidextrous! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF question | Excel Discussion (Misc queries) | |||
SUMIF Question | Excel Worksheet Functions | |||
Another SUMIF question | Excel Worksheet Functions | |||
SUMIF Question | Excel Worksheet Functions | |||
SUMIF question (I think) | Excel Worksheet Functions |