RagDyer:

Thanks for the rsponse... it didn't work.. same "VALUE! error.
I'm thinking, the IF Then Else.. formula.. If cell =text ignore..
Else Add. something like that but I don't know how to do it.
It may take a VB program. but I'm just learning that.
Thanks again for trying. Lovella



Try this:

=SUM(BZ864,CB864:CF864,CA864*BZ864)




Lovella wrote:
I'm working for a company auditing excel worksheets
I have a worksheet with the following formula,
=+(BZ864+(CA864*BZ864)+CB864+CC864+CD864+CE864+CF 864)

This works except where there is text in CF864 (they will insert "n/a")
If there is n/a in the row the formula bombs #VALUE!. My question,
is there a way to add up a range and have is skip a cell if it contains
text? The cell CF is formatted General, accepting numbers or text.

You folks seem so bright, I thought maybe someone has run into this.

Thanks in advance, Lovella

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200511/1