I am trying to figure out a COUNTIF with AND formula while referencing another sheet.

I am trying to create a formula that counts both if the base health is green, and if it is in shift 1. I will be doing this for all of them. If they are red in shift 1, yellow in shift 1, green in shift 2, red in shift 2, yellow in shift 2, green in shift 3, yellow in shift 3, and red in shift 3. Here is the exact part of that sheet I am referencing in this specific formula

Screen Shot 2023-12-17 at 4.11.49 PM.png

I feel like I have tried every formula in the book! Any help would be appreciated.

Thanks!

Find more posts tagged with

Formulas

Countif

Accepted answers

SteyJ

Try this:

=COUNTIFS([Primary Column]:[Primary Column], "Shift 1", [Base Health]:[Base Health], "Green")

or if it's referencing another sheet, do this

=COUNTIFS({Primary Column}, "Shift 1", {Base Health}, "Green")

All comments

SteyJ

Try this:

=COUNTIFS([Primary Column]:[Primary Column], "Shift 1", [Base Health]:[Base Health], "Green")

or if it's referencing another sheet, do this

=COUNTIFS({Primary Column}, "Shift 1", {Base Health}, "Green")

Alicia D

@SteyJ , thank you! That worked perfect.

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.