I'm trying to filter "confirmed" users.
I have a column (DATA!A) where all user names are found, those who confirmed their status are colored in green.
There's another column (DATA!B) where the specific status of the users can be found.
So I have 2 separated functions, one counts confirmed users: COUNTA(valuesByColor("#00ff00", "#000000", Data!A3:A260)
And the other one counts specific status, for example: COUNTIF(Data!B3:B200, "TOP")
Now what I want is a formula that for example counts all "TOP" cells in (B) that are confirmed, which means count only if their respective (A) is green.
Is there any way to do this?
Aucun commentaire:
Enregistrer un commentaire