Counting blank cells when other criteria is met

Emily T.

Hi,

I need to add on top of a formula that counts tasks that are in progress or not started that are past due. The formula below works for that, but now I also need my total to include cells in the target completion date that are blank.

=COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]129:[Target Completion Date]144, <TODAY())

Any suggestions would be most helpful.

Thank you,

Emily

Devin Lee

=COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]:[Target Completion Date], <TODAY()) + COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]:[Target Completion Date], "")

=COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]129:[Target Completion Date]144, <TODAY()) + COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]129:[Target Completion Date]144, "")

Devin Lee

=COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]:[Target Completion Date], <TODAY()) + COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]:[Target Completion Date], "")

=COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]129:[Target Completion Date]144, <TODAY()) + COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]129:[Target Completion Date]144, "")

Emily T.

Awesome! Thank you so much. That worked!