Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Looking for a formula to see the average amount of times something is made throughout the course of the week (Monday-Friday) from date form and name of product
Solved by S. A. in 37 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 28/08/2018 - 06:55
Welcome to ExcelChat!
User 28/08/2018 - 06:55
Excelchat Expert 28/08/2018 - 06:55
Will you provide the data based on which you need the solution?
User 28/08/2018 - 06:57
i cant see anything on the goggle doc side because it is blocked. Refer to column M/N comparing date column A to column b
[Uploaded an Excel file]
Excelchat Expert 28/08/2018 - 06:58
Which sheet is that?
User 28/08/2018 - 06:59
sorry the succ 100
Excelchat Expert 28/08/2018 - 07:00
Could you describe what you need to see in column M and N?
Excelchat Expert 28/08/2018 - 07:00
You want the final result to be in column N, right?
User 28/08/2018 - 07:00
i need to see the weekly average according to the day of week in column n
User 28/08/2018 - 07:00
Excelchat Expert 28/08/2018 - 07:01
What is weekly average? Is it the average from 7 days?
User 28/08/2018 - 07:01
User 28/08/2018 - 07:01
the average per day of week
User 28/08/2018 - 07:02
so i need to see the average occurance on monday, tuesday, wednesday etc
Excelchat Expert 28/08/2018 - 07:02
In which column can we see the fact of occurrence? Just from column A?
User 28/08/2018 - 07:03
column K has the specific day of week
Excelchat Expert 28/08/2018 - 07:03
Okay.. the final question
Excelchat Expert 28/08/2018 - 07:03
For example we take Monday
Excelchat Expert 28/08/2018 - 07:03
Do you want to see the total amount of preps for Monday?
User 28/08/2018 - 07:04
the average total amount of preps for all mondays in this sheet
Excelchat Expert 28/08/2018 - 07:04
What do you mean the average? You mean that we need to take all preps for Mondays and then divide by all Mondays?
User 28/08/2018 - 07:05
average as in..... on average how many preps are being produced on a monday based on this data
Excelchat Expert 28/08/2018 - 07:10
Okay, I will make a solution to calculate that
Excelchat Expert 28/08/2018 - 07:10
Please extend the session once you see the pop up message
User 28/08/2018 - 07:20
any luck?
Excelchat Expert 28/08/2018 - 07:21
Working on it.. will write you back once I finish
Excelchat Expert 28/08/2018 - 07:29
Please have your file ready
[Uploaded an Excel file]
Excelchat Expert 28/08/2018 - 07:30
I add a helper column which shows only unique days of weeks for each date, which allowed us to get the total number of each day
Excelchat Expert 28/08/2018 - 07:30
Then we just divide the total entries per Monday, for example, and divide on the total number of Mondays. In this way we get the average results for each day
Excelchat Expert 28/08/2018 - 07:31
Once you open the file, please force update all the calculations
Excelchat Expert 28/08/2018 - 07:31
So that your days of week would be shown on English
User 28/08/2018 - 07:31
okay thanks

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc