I have a field that has a drop down in each cell. I want to create a formula that will count the total number of names selected in the field. Here’s a screenshot of the field.
This formula for the screenshot above would show a total count of 7.
I also want to be able to create a formula that counts the number of each possible selection. The results of this formula would show:
Carlo - 2
Zach - 2
Mark - 2
Ryan - 1
Thank you in advance for your help!