James Carlo Cruz
Member
Hi there,
Good day! Hope you are well. I am pretty knew to this forum.
I have a question and attached the file for your review.
I would need assistance in counting letter B from Column B to GD.
But the trick is I would only need to count B if its 7 days in a row or more then minus 184 constant value.
IF B doesn't have 7 days in a row it should not be counted.
In the attached file Employee 1 do have a lot of B from Column B to GD but the total that I need to count would only be 12 since Column FS to GD had 7 days or more in a row.
Hope everything is clear
Good day! Hope you are well. I am pretty knew to this forum.
I have a question and attached the file for your review.
I would need assistance in counting letter B from Column B to GD.
But the trick is I would only need to count B if its 7 days in a row or more then minus 184 constant value.
IF B doesn't have 7 days in a row it should not be counted.
In the attached file Employee 1 do have a lot of B from Column B to GD but the total that I need to count would only be 12 since Column FS to GD had 7 days or more in a row.
Hope everything is clear