| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate % of events based on days worked
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). "Karen" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
| HOW TO CALCULATE THE DAYS? | Excel Worksheet Functions | |||
| Counting days worked | Excel Worksheet Functions | |||
Linear Mode
