Count Names
 

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?

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?

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?

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