In the attached spreadsheet I am looking to avg the number of lines for each day of the week.
As I fill in a day I need a formula to total say all the Mondays in the month and give me an avg. Now if I have 4 Mondays in the month of January and I have only filled in lines for 2 of the Mondays I would need the avg of the 2 days not the 4 for the month.
Thanks
Bookmarks