Trying to use COUNTIF with criteria from 2 columns.

I have 2 columns I want to pull from, one is Issue Status should equal 'Open', and second is Target Date which I only want to count if it's in the past. Below is the formula I have, but I'm getting an error.

=COUNTIFS([ERM Target Date]:[ERM Target Date], @cell < TODAY(),[Issue Status]:[Issue Status], [Issue Status]2))

Find more posts tagged with

Accepted answers

Paul Newcome

Try removing one of the closing parenthesis from the end.

All comments

Paul Newcome

Try removing one of the closing parenthesis from the end.

Amy Violette

Awesome! Thank you that worked!

Paul Newcome

Happy to help. 👍️

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.