Multiple Dropdown COUNTIF question

ScionoftheNight ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi, I have two sheets set-up. One sheet is a data-input sheet while the other is a quantitative summary. The quantitative summary is connected to the data-input sheet through cell linkage. For the bolded part of the formula, the cell that it is linking has a multiple dropdown column (it tracks who did what task - sometimes two people do a task). I am trying to track the success/failure rates for each individual operator. If an entry has two operators, the formula won't tabulate it for one of the two operators, but I need it to do that. I tried CONTAINS but it didn't seem to work for me. Any advice? Thanks!

=COUNTIFS({ICE Analysis Range 1}, <1, {ICE Analysis Range 4}, "AF", {ICE Analysis Range 3}, =Date@row)