text in a cell in a numeric formula

[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

 

[T. Valko]

Use the SUM function:

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

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

=SUM(A1:A4) returns 3

 

[Randy Starkey]

Bill,

Here's my actual scenario...

A1+A5+A10+A15

What can I do with that?

Thanks!

--Randy

 

[Peo Sjoblom]

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

 

[Pete_UK]

Try this:

=sum(A1,A5,A10,A15)

Hope this helps.

Pete

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

 

[Randy Starkey]

Cool. Thanks everyone!

--Randy Starkey

Try this:

=sum(A1,A5,A10,A15)

Hope this helps.

Pete

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

 

[Pete_UK]

You're welcome.

Pete

Cool. Thanks everyone!

--Randy Starkey






- Show quoted text -