Countifs with two conditions

topazfae

I was having a hard time with this formula - Not sure why I am getting it wrong.

What I am trying to do is -

If Column A is Student and if Column C has Enrolled or Enrolled - Incompleted, Count. The formula I have is follows:

=COUNTIFS({Courses Projects}, "Student", {Courses Status},OR(@cell = "Enrolled",@cell="Enrolled-Incomplete"))

Find more posts tagged with

Countif

Accepted answers

Matt Lynn ACT

@topazfae You're formula worked for me when I recreated it. I would double check each reference. Sometimes when creating a cross sheet reference it'll save the sheet, but not the column in the sheet. Maybe edit and confirm both references not only go to the sheet, but also show the highlighted column. If not select it or even delete/recreate the references… slowly to confirm they're highlighted before finalizing that reference.

All comments

Matt Lynn ACT

Paul Newcome

Are you getting an error message or an unexpected result?

I notice that when you were typing out what you were searching for, you had spaces on either side of the hyphen in "Enrolled - Incompleted", but you did not have those spaces in the formula. You also have the "d" on the end of "Incompleted" in the typed out version, but that is missing from the formula version.

I would suggest starting with making sure you have matched up exactly what you have in the source data and what you have in the formula.

topazfae

You're right, the formula is correct. I just had to remove the formula and did it again from scratch. Even though the formula is the same, this time, it worked. Thanks.

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.