Counting row depending on 2 criteria

Hello,

I'm trying to count the entries in a column (ID) depending on 2 other columns (Name and Status) values.

I want to know how many rows there are in a file depending on a country Name and a certain status.

I have tried below 2 options but have not succeeded.

=COUNTIF({Customer Impl Action Items Log - Joint ID}, AND({Customer Impl Action Items Log - Joint Status}, "Closed", {Customer Impl Action Items Log - Joint Name} = "UK"))

=COUNTM(AND({ Impl Action Items Log - Internal NAme} = "UK", { Impl Action Items Log - Internal Status} = "Closed")) + COUNTM(AND({ Impl Action Items Log - Joint Name} = "UK", { Impl Action Items Log - Joint Status} = "Closed"))

Is there a different formula to use?

Find more posts tagged with

Accepted answers

Leibel S

Try using a COUNTIFS formula

All comments

Leibel S

Try using a COUNTIFS formula

Caroline Wittig

Thank you that solved the issue.

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.