View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?