"#N/D"
Believe you meant "#NA" <g
Try something along these lines ..
Put in say, B2:
=SUM(IF(ISNUMBER(A2:A10),A2:A10))
Array-enter the formula, i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER
B2 will return the desired sum
The formula will essentially ignore cells within A2:A10
which contain or evaluate to values other than numbers
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"pgco" wrote in message
om...
I want to sum a range of cells with same cells with "#N/D": how can I
to resolve this problem ?
Thank.
|