text in a cell in a numeric formula

  • Thread starter Thread starter Randy Starkey
  • Start date Start date
R

Randy Starkey

Hi,

If I'm adding say 4 cells, and one cell has text in it, is there a way to
disregard the text and get the numeric total? I get a #value! error now. I
can't ignore the cell because sometimes there are numbers in it. I could use
shading, but I really need a text designator in the cell.

Any way to do this would be appreciated.

Thanks,

--Randy Starkey
 
Use the SUM function:

A1 = 1
A2 = text
A3 = 1
A4 = 1

=A1+A2+A3+A4 returns #VALUE!

=SUM(A1:A4) returns 3
 
Bill,

Here's my actual scenario...

A1+A5+A10+A15

What can I do with that?

Thanks!

--Randy
 
As previously stated use SUM


=SUM(A1,A5,A10,A15)

or the somewhat unnecessary

=N(A1)+N(A5)+N(A10)+N(A15)


--


Regards,


Peo Sjoblom
 
Try this:

=sum(A1,A5,A10,A15)

Hope this helps.

Pete

By the way, it was Biff, not Bill !!
 
Back
Top