DCOUNT and DSUM functions

[kennethstrain]

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

 

[Guest]

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,