What did I do wrong THIS time?

Giganews Newsgroups
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?

Replies