View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default DCOUNT and DSUM functions

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