B
bkkpr
I work on a spreadsheet that has 32 columns - each column represents a day in
the month and then there is a month to date total. There are several rows in
each column. I enter in the sales figures into each day (column). My boss
says there is a formula that will give me a daily average which changes each
time I enter in a new days sales figures. How would I do that without having
to change the formula each day to include the most current days data?
the month and then there is a month to date total. There are several rows in
each column. I enter in the sales figures into each day (column). My boss
says there is a formula that will give me a daily average which changes each
time I enter in a new days sales figures. How would I do that without having
to change the formula each day to include the most current days data?