I am pretty limited in my excel knowledge and need some help. I have two columns of data. Column A is the date column B is daily sales. Is there a formula that will automatically update the average for the data that is entered already but will not take into account dates that are not filled in yet? So basically it will update the average based on a daily basis when new data is entered. I hope this makes sense. Thanks.
Perhaps...
=SUMIF(B:B,"<>")/COUNTIF(B:B,"<>")
where column B is your sales data column.
This assumes you don't have figures in column B where there is no date in the date column...
Edit:
If you have a title in B1 then use this instead:
=SUMIF(B:B,"<>")/(COUNTIF(B:B,"<>")-1)
Last edited by NBVC; 02-04-2009 at 02:31 PM.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks