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.

1 Answer

My method needs to add an "Auxiliary column" to get the title for each exercise item. On my sample, the formula is =IFERROR(INDEX(A$1:D$1,SUMPRODUCT(($A$2:$D$6=A11)*(COLUMN($A$1:$D$1)))),"").

Then I enter the formula in Cell A7 and fill to the right, the formula is =IF(SUMPRODUCT(($C11:$C16=A$1)*($B11:$B16))=0,"",A1&":"&SUMPRODUCT(($C11:$C16=A$1)*($B11:$B16))).

Please note, the range of "$C11:$C16" is not stationary, you may use a larger range to let users choose the exercise item.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy