DSUM returns #VALUE!

P

Peter C

=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
 
P

Peter C

No worries, found the answer to my question:
=IF(ISERROR(DSUM(DIVOH,$CX$1,$DG$2:$DG$20)),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FIND and REPLACE characters needed 2
#value error for sumproduct using RIGHT cmd 0
Return Matched Numeric Values across Rows 2
Return SEARCHED Column Number of Numeric Label and Value 23
Return Cell Address of MIN value - array formula 5
Return Numeric Value to their Matched Value Position in Single Column 3
Match 3 Criteria and Return Lowest Numeric Value 16
Return Numeric Labels that have different Numeric Values 8

Top