|
For FH3's criteria in tracker Team 3 : not AV but AU
=IF(AND($V3="X",$AO3="X",AG3="X",AK3="X",AU3="X"), "X",COUNTIF($V3,"X") + COUNTIF($AO3,"X")+ COUNTIF($AG3,"X")+ COUNTIF($AK3,"X")+ COUNTIF($AV3,"X"))
=>
=IF(AND($V3="X",$AO3="X",AG3="X",AK3="X",AU3="X"), "X",COUNTIF($V3,"X") + COUNTIF($AO3,"X")+ COUNTIF($AG3,"X")+ COUNTIF($AK3,"X")+ COUNTIF($AU3,"X"))
|