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 03:31 PM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks