Formula to count the number of cells that contain 3 criteria including name within a list

I have tried a number of formulas and each time run into an error regarding the last item. I want to count a row if a name appears within a list in a cell with a designated date and location within that row.

=COUNTIFS({Class Attendance Range - Date}, [DATE], {Class Attendance Range -Location}, [LOCATION], {Class Attendance Range - Attendance List}, [NAME])

=COUNTIFS({Class Attendance Range - Date}, [DATE], {Class Attendance Range -Location}, [LOCATION], CONTAINS([NAME],{Class Attendance Range - Attendance List}))

=IF(AND({Class Attendance Range - Date}, [DATE], {Class Attendance Range -Location}, [LOCATION], CONTAINS([NAME],{Class Attendance Range - Attendance List}), 1, " ")

=IF(AND({Class Attendance Range - Date}, [DATE], {Class Attendance Range -Location}, [LOCATION], {Class Attendance Range - Attendance List}, [NAME]) 1, " ")

Please help!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Your first one is the closest, but if you are using a reference to a cell within the same sheet as the formula, you need to include either a specific row number or "@row".

Date@row

Location@row

Name@row

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.