Rufus 2019
New Member
- Joined
- Feb 1, 2019
- Messages
- 11
I am going to try and explain this as best I can. Hopefully it will be clear enough for somebody to understand.
In cell A1 and A2 I have a list of exercises I choose from that are in a drop down list, lets say Sn and Squat. They are the same exercise but I can choose different exercises in each cell. I cell B1 and B2 is the total number of reps done for that exercise in A1 and A2.
On another sheet in the workbook I want to count the total number of reps for each separate exercise, Sn in cell A2 and Sqt in cell B2. I am trying to come up with a formula to do this. Also there could be a case where both cells contain the same exercise (A1 and A2 =Sn) on the original sheet. Can anyone help me please. Thanks a lot guys.
Rufus
In cell A1 and A2 I have a list of exercises I choose from that are in a drop down list, lets say Sn and Squat. They are the same exercise but I can choose different exercises in each cell. I cell B1 and B2 is the total number of reps done for that exercise in A1 and A2.
On another sheet in the workbook I want to count the total number of reps for each separate exercise, Sn in cell A2 and Sqt in cell B2. I am trying to come up with a formula to do this. Also there could be a case where both cells contain the same exercise (A1 and A2 =Sn) on the original sheet. Can anyone help me please. Thanks a lot guys.
Rufus