Average of a range of numbers....

All, i understand that my requirement is not clear!

I have added a second tab (requirement)on my attached spreadsheet that hopefully will help.

The requirement is where i want to get to in that in cells B2 to B25, i would like the average of all Mondays throughout the year from tab Firm and Forecast. Cells C2 to C25 i would like the average of all Tuesdays and so on.

Now as i say ideally for the whole year but with the Mondays figure being very varied (ranging from 8-14), i'm not sure whether an average is the best way forward. Even having 12 seperate months, ie tab 2 (requirement) for each month may not be the way.

This is where the low, core and high comes in where i may be able to group certain months where the demand figures are the same.


So i may have the following:

• One tab showing an average over the year
• 12 tabs showing the averages for each month
• 3 tabs showing groupings of similar months

Any help greatly apprecited.

Simon




This is probably a very simple query for most but here goes...


Hi all, I have a range of figures (demand) that covers a whole year (2014) (File attached).

The issue I have is that I want to try and get to a point where I can have an "average" figure for each day of the week in January ( and February etc.), as each figure in January at present is different.

At present, I can only think of doing an average for Mondays in each month and so on. I will then have January with an average Monday, Tuesday etc and each subsequent month.

This obviously means I will have 12 demand periods.

Following on from this i would like to consolidate the 12 periods into potentially 3 periods of possibly low, core and high periods but not sure how to go about this?


Many thanks as always for any help offered.

Best wishes

Simon

Cross posted here:
http://www.mrexcel.com/forum/excel-q...e-numbers.html

A message to forum cross posters, please read the following link:
http://www.excelguru.ca/node/7