Thank You very much!!!

"Chad" wrote:

Try using the sum formula in conjunction with the countif formula. For
example,

=SUM(range)+COUNTIF(range,"assist"), where range is the range you would like
to add.

Hope this helps!
-Chad

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