I have a worksheet for recording attendance at a weekly meeting. Column A has a list of names of people who are supposed to be attending. Starting in Column B, is the first weekly mtg. (1/7/08), Column C will be (1/14/08), and so on til the end of the year. John Doe's name will be in A-5. Tic marks will show that he attended on (1/7/08) and (1/14/08) but no tic mark means he was not attending for (1/21/08) or (1/28/08). At that point he is 50% in attendance YTD.
I am desiring to insert a column that represents each member's percentage of attendance Year To Date.
All cells representing attendance have a tic mark. All cells that have no attendance have nothing in the cell.
Is there a formula that I can use to keep a YTD running percentage of attendance for each member? If there is a way to do this, please advise how.
thank you.
Bookmarks