Finding the percentage
 

I am trying to find the percetange of cells that contain values. The cells
contain dates of trainings that my staff attended. I want the formula to
count the number of cells that have dates in them and then divide by the
total of number of staff on that shift. Can I accomplish that in one cell?

Finding the percentage
 

That's almost certainly achievable but a few points:-

Which cells? An Excell 2003 worksheet has more than 16 million, can you
narrow it down a bit.
How do we establish the total number of staff on 'that' shift?
Maybe an example of your data layout.

Mike


"Anthony P." wrote:

I am trying to find the percetange of cells that contain values. The cells
contain dates of trainings that my staff attended. I want the formula to
count the number of cells that have dates in them and then divide by the
total of number of staff on that shift. Can I accomplish that in one cell?

Finding the percentage
 

hi
you're a bit foggy about how your data is layed out so i'm going to assume
alot.
assume that you have 6 employees in column a2:A7.
assume that 3 of those employees have a train date in column b2:B7.
in C2 put....
=count(B2:B7)/Counta(A2:A7) format as percent.
or if you know the number of employees...
=count(B2:B7)/6

anyway that's the idea.
adjust the above formula to suit your data.

Regards
FSt1

"Anthony P." wrote:

I am trying to find the percetange of cells that contain values. The cells
contain dates of trainings that my staff attended. I want the formula to
count the number of cells that have dates in them and then divide by the
total of number of staff on that shift. Can I accomplish that in one cell?

Finding the percentage
 

You could try:
=COUNT(range)/COUNTBLANK(range)

As Mike pointed out, your shift requirement would have to be
determined somehow unless the ranges are grouped by shift.

On Jun 9, 1:55 pm, Anthony P. <Anthony
wrote:
I am trying to find the percetange of cells that contain values. The cells
contain dates of trainings that my staff attended. I want the formula to
count the number of cells that have dates in them and then divide by the
total of number of staff on that shift. Can I accomplish that in one cell?

Finding the percentage
 

Awesome I finally completed it. Thanks so much I just used "count(range) / #
of employees" I think I was trying to make it more complicated than it should
be. Once again thank you!!!!

"FSt1" wrote:

hi
you're a bit foggy about how your data is layed out so i'm going to assume
alot.
assume that you have 6 employees in column a2:A7.
assume that 3 of those employees have a train date in column b2:B7.
in C2 put....
=count(B2:B7)/Counta(A2:A7) format as percent.
or if you know the number of employees...
=count(B2:B7)/6

anyway that's the idea.
adjust the above formula to suit your data.

Regards
FSt1

"Anthony P." wrote:

I am trying to find the percetange of cells that contain values. The cells
contain dates of trainings that my staff attended. I want the formula to
count the number of cells that have dates in them and then divide by the
total of number of staff on that shift. Can I accomplish that in one cell?