Home

Question on calculating totals from a range of differing exercises

Simon_McCrum
New Contributor

I have an exercise log with a drop down menu for Running, Hiking and Cycling. I would like to be able to add up the total distances for the different exercises.

thank you!

2 Replies
A quick way would be to highlight your data and create a Pivot Table (Insert > Pivot Table). Then drag your distances column into the values box and your categories into the rows box
That's brilliant Wyn, that works a treat. Thank you!
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies