2 Replies Latest reply on Nov 9, 2009 8:22 AM by Lumpia

    Count data in rows?

    Lumpia Level 1

      I have a kinda weird/advanced count situation for a work schedule project.


      The table is like so:




      So, to explain, if one person is OFF 2 days in a row, then add 1 to the grand total.  If 2 people are OFF 2 days in a row, then you'd add 2 to the total.  However, if a person is OFF one day (as in row 2) and not OFF again the following day, then don't add 1 to the total.  By the way, this is a schedule for the whole year, and there is a total for each week.