Finding the percentage

[Anthony P.]

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?

 

[Mike H]

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

 

[FSt1]

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

 

[Reitanos]

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.

 

[Anthony P.]

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