I am looking to count how many audit types, "DD", did my auditor "Brian" do. I am referencing and different sheet.
=COUNTIF({MB Intake Audits - 2024 Type of Audit}, "DD", AND({MB Intake Audits - 2024 Auditor Name}, "Brian"))
Try:
=COUNTIFS({MB Intake Audits - 2024 Type of Audit}, "DD", {MB Intake Audits - 2024 Auditor Name}, "Brian"
Well that kinda worked @Nic Larsen. It returned 0 when I know I have DDs and Brian in those columns.
I tried this too.
=COUNTIF({MB Intake Audits - 2024 Type of Audit}, "DD", CONTAINS(“Brian”, {MB Intake Audits - 2024 Auditor Name})
Things that come to mind - Are your cross-sheet ranges set to the entire column? Is your Auditor Name column set up as contact list or just a text/number? Is there more than one name listed in the Auditor Name column?
I would use a COUNTIFS over a COUNTIF formula. You can also test each section to confirm you are getting results before joining them.
So try:
=COUNTIFS({MB Intake Audits - 2024 Type of Audit}, "DD"
=COUNTIFS({MB Intake Audits - 2024 Auditor Name}, "Brian"
=COUNTIFS({MB Intake Audits - 2024 Type of Audit}, "DD" formula works but the Brian one does not. Currently my column is text but it will change to a contact list.
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.
