Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUM
I want to sum a range of cells with same cells with "#N/D": how can I
to resolve this problem ? Thank. |
#2
|
|||
|
|||
"#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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|