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
Please read the rules on posting and re-title your question, then you may get a reply
http://www.excelforum.com/showthread.php?t=613916
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks