Count if on two columns

I have a sheet that pulls from another, I need to do a count if for two different columns. I use this formula for one, how do I add another?

=COUNTIF({Date 2}, [Start Date]@row)

I need something like: =COUNTIF({Date 2}, [Start Date]@row), =COUNTIF({Review Board}, [ReviewBoard]@row=XX)

It is an agenda sheet that has a set number of minutes, then I subtract minutes based on the number of topics added for that date. Now I need to also do a type of lookup for the Review Board. There are three Review Boards and in many cases the dates are now the same.

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey Leann

The syntax is correct. When you entered it into your destination sheet - did you get what you expected?

oops you forgot an @row

=COUNTIFS({Date 2}, [Start Date]@row, {Review Board}, [Oncology TAG]@row)

All comments

Kelly Moore

Hey @Leann Gibson

The COUNTIF (singular) function works when a single criteria is involved.

The COUNTIFS (plural) function works for any number of criteria - from one to whatever. My personal preference is to only use the plural version because of its versatility.

The syntax is

=COUNTIFS(range1, criteria1, range2, criteria2, etc)

Does this get you what you need?

Kelly

Leann Gibson

I current formula is: =COUNTIF({Date 2}, [Start Date]@row)

I want to add if the {Review Board} is + to Oncology TAG

Would it be: =COUNTIFS({Date 2}, [Start Date], {Review Board}, [Oncology TAG]@row)

Kelly Moore

Hey Leann

The syntax is correct. When you entered it into your destination sheet - did you get what you expected?

oops you forgot an @row

=COUNTIFS({Date 2}, [Start Date]@row, {Review Board}, [Oncology TAG]@row)

Leann Gibson

Cannot get it to work, must be something on my side. Thanks for the ideas.

Leann Gibson

Figured it out, the second criteria needed to be the name of the column.

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.