LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default Average Calculation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average IF with calculation Chris Excel Worksheet Functions 2 February 16th 08 12:40 AM
Difficult Average Calculation <HELP jk Excel Worksheet Functions 4 July 6th 06 06:32 PM
Calculation help from average total Middlemix Excel Worksheet Functions 1 February 16th 06 01:26 PM
average calculation blackstar Excel Discussion (Misc queries) 1 February 4th 06 07:46 PM
Average Calculation smallcap Excel Worksheet Functions 6 October 28th 05 12:36 AM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"