Hi - I have seen similar threads but none that cover what I am needing. I have a spreadsheet with a Calendar Tab that I enter data into to track Employee Illness occurrences. I have a Summary Tab that sums up all the info I need. The spreadsheet is configured to reset every 365 days. What I need is a formula in G7 on the Summary tab that would start when cell D7>40 as 1 occurrence and track subsequent occurrences of Employee Illness from the Calendar tab. The trick is that consecutive dates need to be treated as 1 occurrence. I have attached the spreadsheet with info on the Summary tab that I need. Thank you in advance. I have tried Sumif, Sumproduct. I think it's a simple IF/AND, but I can't get it to work.
Bookmarks