Count Rows with Multiple Criteria

Steglio

Hi all,

I am trying to count the Row withe multiple criteria

In this case, I want to count the rows where I have "Rib Drg" & "-A-"

I have tried with Countif and Countifs with the OR & AND but could not work it out

Thanks!

Find more posts tagged with

Account and User Management

Countif

Accepted answers

All comments

Steglio

Pressend post comment too soon. Please see screenshot

Matt Johnson

Hi @Steglio

Maybe give this formula a try.

=COUNTIFS(Provider:Provider, "Rib Drg", [Status Received]:[Status Received], "-A-")

I hope that helps.

Matt

Steglio

Hi Matt, thank you very much, that worked!

What if I want to add another criteria in the provider column like

Rib Drg & Mark Drg?

thank you

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.