converting text to numerical value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All,

I am working on a worksheet for our company, and want to know if there is a
way to make a formula that would calcululate the number of people involved in
a specific program. Basically i would like it to calculate in this way: If
cell contains text (i.e. a person's name), then that cell would equal 1.
Then I could make a basic sum calculation all of the cells containing text.
If the cell were blank, the value of that cell would be zero, and would not
be added to the total number of participants. This is a yearly activity
report, and would need to be ongoing. Does anyone know of any way to perform
this calculation or any alternatives to doing so? Any assistance at all
would be greatly appreciated.
 
Hi

how about counting the number of cells with text in them?
e.g.
=COUNTA(A1:A10)
where A1:A10 is the range where your employees names are to be listed


Cheers
JulieD
 
Morning, there are a few ways to do that. The simplest is
using COUNTA, this will count text in cells, while not
counting empty cells.
=COUNTA(Cell range)
HTH
Kevin M
 
Hi,

Let's say the names are in column A from cells 1 to 100, then you use
the formula

=COUNTA(A1:A100)

That will give you a count of cells which aren't blank.

Regards

Govind.
 
Back
Top