What do you mean "add up the numbers plus the word assist"?

In my mind you cannot add a number with a text.


Diana Wrote:
I would like to know how to count text and numbers on a column. I have
about
70 names in a column and next to them I keep track of how many hours
they
were present for meetings and I have 'assist' if they were out. How do
I get
excel to add up the numbers plus the word assist? Can someone please
help?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=469917