Count/Total each choice within a Microsoft List Choice column

Melinda Grant 25 Reputation points
2024-05-20T05:36:15.0933333+00:00

I'm trying to track hours spent in 4 standard activity types in a Microsoft List. Although it is possible for other activity types to be added to the list, I only need to track the four standard types.
The list is populated by a form that a user completes for each time they do an activity. The questions include "What activity type were you doing?" (a choice) and "How many hours did you spend?" (a text/number). I have a flow that then populates the list.
In the list below, how is it possible to total how many hours were spent in Work, Social, Family and Admin activities?

Is there another way to ask these questions, display these columns and/or find out the totals I'm looking for??
My ultimate goal is to check that each person has spent at least 1 hour in each of the 4 activities and tracked at least 10 hours in total.
User's image

Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
624 questions
0 comments No comments
{count} votes