Average Formulas So Far

[Dearster]

New to Excel so bear with me.

Basically I have a table of percentages for each day of the week. Another one for each week of the period. Another one for each period of the year.

Obviously all these calculations aren't going to be visible straight away say if we are halfway through the first period of the year. So how can I calculate an average which automatically updates depending on what has passed so far.

For example say we were on Wednesday I would need it to calculate an average of SUnday, Monday, Tuesday and Wednesday. Then as soon as Thursday comes include that as well.

Thanks.

 

[Dearster]

Just to add I'm using Open Calc but I'm pretty sure they are quite similar.

 

[aravindhan_31]

Assuming your having Days in Column A & Sales in Column B and data starts from A2

Col A Days --------- Col B Sales
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
---------

in B9 type this formula =SUM(B2:B8)/COUNT(B2:B8) which will give you average so if something is blank it ignores.
same logic can be used for period year etc.. sum of all / count of all

 

[Gerald Higgins]

If you are using Excel's AVERAGE() function to calculate an average for several cells, some of which are empty, then Excel won't include the empty cells in the calculation.

For example if your data looks like this
Sun....1
Mon....2
Tue....3
Wed.....
Thu.....
Fri.....
Sat.....
Excel will calculate AVERAGE() as 2 (the average of 1, 2, and 3).

BUT, if your cells for Wed, Thu and so on contain 0 instead of blank, the 0 WILL be included in the average calculation.

There are various ways around this, if that's what you need to do.

 

[Dearster]

Thank you so much for your help