View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Calculate % of events based on days worked

I need to determine a % of events based on the number of days an individual
has worked. My spreadsheet is set up by the week and QTD & YTD totals. The
% needs to be calculated each quarter and a total % for the year. I'm not
sure how to start. I had it set with SUM(D3:D15)/65. That works as long as
each wk is completed. If not, the calculation is wrong. Is there calculate
days based on weeks completed?
--
Thanks for your assistance!

Karen