Counticon

Hi,

I’ve been trying to set up a calculation using the “if” and “counticon” functions, but am struggling to get a working formula.

I have my class linked to google classroom, and assignment marks are imported.
I have set a quick calculation to get the percentage/colour.
For any student who has not handed in the homework, I have added the cross icon (❌) .

I want to have a formula which counts how many crosses for each student, then returns a 1️⃣/2️⃣/3️⃣ depending on how many homework handed in (or in this case, how many are not handed in )

Thanks

I believe I’ve found a work around.
Probably very convoluted and not needed, but does what I’m looking for currently.
It needs editing for each individual term/class, so that will be time consuming, and so I would still love any support/ideas for easier versions.

Thanks