Forum Discussion
Excel Solution Required
Hello hive mind, I'm using Excel on a Mac. PART ONE So I have a cell in Excel that contains a drop down, the drop down has the options: Pass, Merit, Distinction, Fail Later down the spreads...
PART ONE:
Let's say the cells with the drop-down are A2:A100.
Number of cells with Distinction:
=COUNTIF(A2:A100, "Distinction")
And similar for the other options.
PART TWO:
If the cells are colored directly (not through conditional formatting), counting cells with a specific color requires VBA, so all users would have to allow macros. And it would only work in the desktop version of Excel for Windows and Mac, not in Excel Online, nor on iOS/Android.
Do you really want this?