P pgco Feb 23, 2005 #1 I want to sum a range of cells with same cells with "#N/D": how can I to resolve this problem ? Thank.
I want to sum a range of cells with same cells with "#N/D": how can I to resolve this problem ? Thank.
M Max Feb 23, 2005 #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
"#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
