DCOUNT and DSUM functions

[[email protected]]

Hi,
I have a DCOUNT formula in Excel 2003 which works perfectly and comes
up with the required result of 556.
=DCOUNT('Raw data'!$B$4:$U$4891,"ABS approach est error",'Dfunction
criteria'!$K$4:$K$5)

However, asking excel 2003 to do exactly the same calculation but for
the DSUM function doesn't work at all. It produces #N/A

=DSUM('Raw data'!$B$4:$U$4891,"+- approach est error",'Dfunction
criteria'!$K$4:$K$5)

Am I missing something here at all?
Cheers
ArtySin

[Gary L Brown]

There is probably at least one cell that contains #N/A in the data range.
DCount() will ignore it. DCountA() will count it. DSum() will return #N/A.
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"[email protected]" wrote:

> Hi,
> I have a DCOUNT formula in Excel 2003 which works perfectly and comes
> up with the required result of 556.
> =DCOUNT('Raw data'!$B$4:$U$4891,"ABS approach est error",'Dfunction
> criteria'!$K$4:$K$5)
>
> However, asking excel 2003 to do exactly the same calculation but for
> the DSUM function doesn't work at all. It produces #N/A
>
> =DSUM('Raw data'!$B$4:$U$4891,"+- approach est error",'Dfunction
> criteria'!$K$4:$K$5)
>
> Am I missing something here at all?
> Cheers
> ArtySin
>
>