
What Function to Use? How to Write the Formula?
I am a music teacher tracking how often lessons get missed and which day misses the most. I can't post the file for privacy.
Column A and C are popup menus. Column A has all student names loaded and Column C has each day of the week loaded. How can I tell Numbers to count the number of times each day shows up? Do I need to remove the popup menu and just type the letters each time a student misses? Thanks!