What Causes DSUM to Report #DIV/0!?

[Dean Hinson]

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?


--
Regards,
Tom Ogilvy

"Dean Hinson" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Dean Hinson]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>