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
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