|Subject:||What did I do wrong THIS time?|
|Posted by:||Nick Xylas (nickxyl…@wmconnect.com)|
|Date:||22 Jan 2007|
I am trying to add up the value of the numbers in a range of cells in
which some cells contain numbers and others contain text. In the sum
cell, I typed the formula "=SUMIF(A1:C9,ISNUMBER(A1:C9),A1:C9)". The
result should have been 434.5, but actually came out to zero. Can
anybody tell me what is wrong with my formula and how to correct it?