Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM returns #VALUE!
=DSUM(DIVOH,$CX$1,$DG$2:$DG$20)
I have the above DSUM that refers to a "DIVOH" workbook, and returns #VALUE! instead of a numerical 0 if the search is unsuccesful. Note that it returns numerical results on successful searches. Q: How do I get this to return a numerical nil for searches that cannot find what they are looking for, instead of the #VALUE that is currently being returned? Thanks for any assistance. Peter C |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM returns #VALUE!
No worries, found the answer to my question:
=IF(ISERROR(DSUM(DIVOH,$CX$1,$DG$2:$DG$20)),0) "Peter C" wrote in message ... =DSUM(DIVOH,$CX$1,$DG$2:$DG$20) I have the above DSUM that refers to a "DIVOH" workbook, and returns #VALUE! instead of a numerical 0 if the search is unsuccesful. Note that it returns numerical results on successful searches. Q: How do I get this to return a numerical nil for searches that cannot find what they are looking for, instead of the #VALUE that is currently being returned? Thanks for any assistance. Peter C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with GEOMEAN - returns #NUM error | Excel Worksheet Functions | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions | |||
When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
DSUM frustrations | Excel Worksheet Functions |