The SUM function ignores text values, so you could use

=SUM(A1:C1)
or
=SUM(A1,B1,C1)

Both formulas will ignore any non-numeric values. However, if a cell
has an error in it (e.g., #VALUE), SUM will return that error. To sum
a range that has error values, use

=SUM(IF(ISERROR(A2:C2),0,A2:C2))

Since this is an array formula, you *must* press CTRL SHIFT ENTER
rather than just ENTER when you first enter the formula and whenever
you edit it later. If you do this properly, Excel will display
the formula enclosed in curly braces { }. The formula will not
work properly if it is not entered as an array formula. For
much more information about array formulas, see
http://www.cpearson.com/Excel/ArrayFormulas.aspx.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 8 Dec 2008 12:31:01 -0800, Jamie Thompson <Jamie
wrote:

I have to add three cells together to get a total. The second cell could
possible have text in it. How do I use the istext formula?