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.
|