Count Names

D

Diana

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

Chad

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
 
D

Diana

Thank You very much!!!

Chad said:
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
Click to expand...
 
M

Morrigan

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

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