SUM

P

pgco

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

Thank.
 
M

Max

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