Multiple Dropdown COUNTIF question

ScionoftheNight

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)

Paul Newcome

CONTAINS should have worked...

 

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

 

If that doesn't work, try this with a FIND function...

 

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