Counting consecutive cells after 4 or 12 occupied cells

[HSCM]

I have a spreadsheet that I use to track days off. One allows someone to be off for four days in a row, however if they are off five or more consecutive days then I need to count the total consecutive days off. I have the same issue with those who are able to take 12 days off in a row, however if they take more than 12 consecutive days off I need to count those as well.

The four day spreadsheet is tracked by using the letter P. The 12 day sheet uses LV.

Any suggestions?

[Marcol]

Any suggestions?

Yes, post a sample workbook!

Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[HSCM]

[url]http://www.excelforum.com/[/ur

I hope this helps.

[RobertMika]

Does F=P and HLV to LV according to your previous post?
From the workbook you have posted do you expect only the 5 "F" to be counted?

[HSCM]

With this sheet HLV and TLV can have 12 consecutive days and the count be zero, BUT if there are 13 consecutive days ALL count. So 13 consecutive days = 13, 14 consecutive days = 14, etc. The same for the F; if there are 4 consecutive days they count as Zero, but if there are 5 consecutive days, ALL days count. This also needs to count throughout the month, so if there are any repeat consecutive days, they continue to count.

HSCM