Skip to main content
L
Lumpia
Inspiring
November 5, 2009
Question

Count data in rows?

  • November 5, 2009
  • 1 reply
  • 487 views

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.

Thanks.

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
November 5, 2009

Where is that image coming from?  Is it an excel spreadsheet, or a formatted query output.  If the latter, the query and the output code is more helpful than the image.

L
LumpiaAuthor
Inspiring
November 9, 2009

This image is from an excel spreadsheet that needs to be turned into an application.  Any programming ideas would be appreciated.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices