View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Ignoring #N/A in a DSUM function

hi, Robert !

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)


"my" dsum(... function ignores error values (#name?, #value!, #div/0!, #n/a!, etc.)

could you be a little more specific on "what" you have/get/expect/... -?-
regards,
hector.