What Causes DSUM to Report #DIV/0!?

[Guest]

Hello All,

I am using a DSUM function to sum based on criteria. The data and criteria
looks good. I have been unable to find documentation on this error for this
function. Has anybody else come accross this? I am on Office 2003.

Thanks, Dean.

 

[Tom Ogilvy]

does one of the cells being summed contain this error?

 

[Guest]

Yep... had to sort the worksheet to find it. Thanks!