What Causes DSUM to Report #DIV/0!?
 

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.

What Causes DSUM to Report #DIV/0!?
 

does one of the cells being summed contain this error?


--
Regards,
Tom Ogilvy

"Dean Hinson" wrote in message
...
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.

What Causes DSUM to Report #DIV/0!?
 

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

"Tom Ogilvy" wrote:

does one of the cells being summed contain this error?


--
Regards,
Tom Ogilvy

"Dean Hinson" wrote in message
...
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.