Percentage Of Cell Value To Number Count

  • Hey guys,

    I know for some of you this will be pretty simple but im having trouble figuring it out. Attached is a shortened version of what i am trying to do. I want the Percent Attendance column to represent the cumulative percentage(hope I used the correct phrase). So for Person 1, it should currently say 100%, person 2 it should say 66.67% and so on. There are 5 days that i want to get the percentage, but because we haven't gotten to 2 of them yet, using a regular sum formula for the entire five days gives me the wrong values. Any thoughts?



  • Re: Cumulative Percentage Values

    Thanks Robert, I figured it was something simple. Much appreciated on the quick response.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!