View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RobertK RobertK is offline
external usenet poster
 
Posts: 28
Default Ignoring #N/A in a DSUM function

I have a column to add that contains some #N/As. I'm using a dsum function
and need to be abke to add the column while ignaring the #N/As. The dsum
formula I'm using is:

=DSUM($A20:$AS1998,33,$A2002:$A2003)
--
Robert K