Hello,
Thank you in advance for any help you can provide!
Here is my problem:
I have this Countifs formula =COUNTIFS(Milestones!F7:F63,FALSE,Milestones!I7:I63,"<"&TODAY())
Whereas, F has single cell linked checkboxes, and I is a column of "planned completion" dates. The dates are merged cells accounting for multiple rows/checkbox actions. (One milestone can have multiple actions, if any action is unchecked and the overall milestone date has passed, it should count the number of checkboxes as the number of past due.)
What I would like is for the formula to count if a checkbox is unchecked AND the planned completion date has already passed, thus giving me a number of actions that are past due. What is happening now, as far as I can tell, is that the formula is counting the number of dates that are past due, instead of the number of actions. Since the dates are merged cells, it is giving me the answer of 2 when there should be 7.
Is it possible using merged cells, and if not, is there a workaround you can think of??
Thank you!!!
Bookmarks