SUM
 

I want to sum a range of cells with same cells with "#N/D": how can I
to resolve this problem ?

Thank.

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