COUNTIF(AND) FUNCTION

Hi again,

I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met.

the date is in the past
the progress status is not "Complete"

=COUNTIF(AND({Due Date Range}, <TODAY(), {Progress Range}, <>"Complete"))

#2 can also be accomplished by saying the {Done Range} is not checked.

Please advise where I am going wrong.

Thanks

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Sarah_lee123

Update, I figured this one out

=COUNTIFS rather than =COUNTIF

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.