Sum not including writing
 

Along with numbers, I have to put text into several cells, mainly astericks
and some letters, but I also want to sum these cells. How do i sum the
numbers and exclude the text? Please help!!

Sum not including writing
 

Don't do it that way.

Put the indicator in an adjacent column.

You're life (and formulas) will be much easier.

Be18 wrote:

Along with numbers, I have to put text into several cells, mainly astericks
and some letters, but I also want to sum these cells. How do i sum the
numbers and exclude the text? Please help!!

--

Dave Peterson

Sum not including writing
 

SUM ignores non-numeric cells
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Be18" wrote in message
...
Along with numbers, I have to put text into several cells, mainly
astericks
and some letters, but I also want to sum these cells. How do i sum the
numbers and exclude the text? Please help!!