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.
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.