+ Reply to Thread
Results 1 to 4 of 4

Percentage Question

  1. #1
    lsmft
    Guest

    Percentage Question

    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.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    =countif(A1:A10, "x") / rows(A1:A10)

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Assuming you have the meeting dates in B4 across try this formula for row 5

    =COUNTA(OFFSET(B5,,,,MATCH(TODAY(),B$4:CA$4)))/MATCH(TODAY(),B$4:CA$4)

    .or with CSE...

    =AVERAGE(IF(OFFSET(B5,,,,MATCH(TODAY(),B$4:CA$4))="x",1,0))

    format as percentage

  4. #4
    lsmft
    Guest
    Thank you gentlemen for your help, however I could not get either of these formulas to work in my case.
    I did what I wanted though, but not as neatly as should be. I dedicated a cell to "date" and then another cell to week of year using the date cell serial number in the roundup formula and by division got my percentage that way.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1