I’m trying to make an exercise spreadsheet to count sets for a certain muscle group.
I organized movements into muscle groups.
Then, I wanted an user-facing input section like this, where the user could use a drop down menu, enter an exercise, and the number of sets.
Then, a statistics page would list “Chest: 3, Front Delts: 2, Back: 2” for example.
I tried using COUNTIF and MATCH but didn’t get anything usable.
Any help is appreciated.