Excel Question

Maybe some excel gurus can help me out here, or maybe just someone who's not retarded like me.

I have an excel worksheet that list my store's daily totals for the month.
I want to get an figure to show me what I average, per day, for the current month. Easy except that if the month isn't over I don't want it to average the days that haven't happened yet.

Example: cells A1 to A31 have a dollar figure for each day of the month (1-31).
If I do just a regular average formula it will look like this: =AVERAGE(A1:A31), this will add up all the totals and divide it by 31.
My dilemma is this, take today, it's December 26th, so to get the daily average it should divide the total sales by 26 in order to get the real time average, but with the regular formula it will always divide by the total number of days in the month, rather than only just the days that have elapsed.

Thanks for the help.

There is probably a more elegant solution to this, but I would make a new column where the cells next to your daily total has a IF-condition that says if your total for the day is larger than zero, then show 1.

If you then are on day 26, you will have 26 cells with a 1 in them. To get the average for the month so far, use the sum of the full range of the new cells to divide with and you will always use the number of days for which you have entered a total.

Is it a bit difficult to describe in writing like this, but it will work so just ask if anything is unclear.

If the cells have nothing in them, it should only average the cells that have amounts in them. So even though you have 31 cells selected, Excel will only average the 26 that have amounts in them and will include the next days day and total when you enter it in. So, it would probably be easiest to leave the cells representing days in the future with no sales completely blank instead of with a $0 so Excel won't count them.

That worked, thanks. I knew that it had to be something simple.