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

Options

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!