[Quinta]

Originally Posted by XinKer Kim

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"))

Thank you! I sometimes have trouble keeping track of issues like this but I do try to fix and minimize them (they arise because I make changes in one sheet or my own workbook and do not use them in the public tracker correctly).

I will work on making this fix and others I find and update the Tracker as soon as I can. There will likely be a new version tomorrow (Saturday at latest). This should be the final version so I will try to recheck everything.