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
hi
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
yes
Excelchat Expert
28/08/2018 - 07:01
What is weekly average? Is it the average from 7 days?
User
28/08/2018 - 07:01
monday-friday
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.