Calculate % of events based on days worked

G

Guest

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?
 
G

Guest

The average function will ignore blank cells. So you might use
=average(d13:d15)/5 to get the daily average, assuming that column D has the
weekly totals for each week worked (and no data entered for any weeks not
worked).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is there a formula to count days someone worked? 3
calculate percentage of pay based on days old 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculating total number of days 3
Calculate the number of weeksdays based on a cell value 8
Calculate total metric based on sum of metric over specific time f 1
Calculate Amount Based on Year 3
Automatically calculate days between dates 3

Top