Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to calculate the average client visit days for our sales staff & I'm
stumped. Last year I entered each week's total visit days separately and my spreadsheet was large. This year I thought I'd be clever and enter a monthly total instead. I created an abbreviated example of my spreadsheet below. I feel silly, but I can't figure out how to get the average visit days per week based on the total visit days per month. Can you help with the calculation formula? Thanks! Visit days per week: ? Total visit days : 25 Name: John Doe Jan 7 Feb 10 Mar 8 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average IF with calculation | Excel Worksheet Functions | |||
Difficult Average Calculation <HELP | Excel Worksheet Functions | |||
Calculation help from average total | Excel Worksheet Functions | |||
average calculation | Excel Discussion (Misc queries) | |||
Average Calculation | Excel Worksheet Functions |