# Formula Question

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?

B

#### Barb Reinhardt

=average(B2:AA2) will average values in non blank cells.

B

#### bkkpr

Thanks Barb. But I think I did something wrong.
I have 17 days of sales entered in to this spreadsheet so far. When I take
the MTD total and divide by 17 I get a different #than what this formula is
giving me.
Any ideas?

S

#### Sheeloo

If you are dividing the MED total in row 2 then it should match with the
result of the formula given by Barb. Make sure that cells where you have not
entered data so far are actual blank. Select them and choose Clear All from
Alternately enter the result you are getting from Barb's formula in the
remaining columns of row 2 and check with MTD/31 (assuming your are in Jul
)

B

#### bkkpr

Thanks for the help!

Sheeloo said:
If you are dividing the MED total in row 2 then it should match with the
result of the formula given by Barb. Make sure that cells where you have not
entered data so far are actual blank. Select them and choose Clear All from