Counting blank cells when other criteria is met

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

Find more posts tagged with

Formulas

Accepted answers

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, "")

All comments

Devin Lee

Emily T.

Awesome! Thank you so much. That worked!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.