Excel, a sum for calculating the average spend

[pakolainen]

trying to do a sheet for the wife. one of the fields is the average spend per
customer per day, resulting in a total average spend after the 7 day week.

but the total box needs to be updating itself daily.
so if monday average spend was 70, then the total box reads 70
tuesday is 60. so the total box reads 65 ( 70 + 30 / by 2 days.
the line is for 7 days. i have tried
(B2:B8)/7, but this gives a divide of 7 when only 1, 2, 3 ,4 ,5 ,6 days data
has been entered.

any ideas

thanks in advance

 

[Shane Devenshire]

Hi,

Try something like this =AVERAGE(B2:B8), as long as cells in column B are
empty until the given day this will work just fine.

If this helps, please click the Yes button

Cheers,
Shane Devenshire