Forum Discussion
SharePoint - Sum values in a column based on value in a separate column
Hello. I'm fairly new to SharePoint, but have some experience. Using my "Irradiation Entries" list, I am wanting to sum the values in "Total uAh" for the corresponding "Rabbit Body ID" values in a separate view or separate list called "Rabbit Log". What would be the best way to go about this?
I appreciate any help in advance...Thanks for the time and consideration!!!
Kyle_Chesshir create a separate view for each Rabbit Body I and edit the view. For each view set the filter to the Rabbit Body ID equals, e.g AZI-0058-001 etc, then select Totals and select sum from the dropdown for the Total uAh column. Then click OK.
The total hours for that ID will be shown at the bottom of the view.
If you want a separate list then you'll need to build a flow in Power Automate.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)- Thanks, that makes sense! But would it be possible to have a summary page that lists the Rabbit Bodies on one page (as shown in my example)?
Kyle_Chesshir only by building a flow in Power Automate which does the calculations then updates a separate list. SharePoint/Lists cannot loop through items and sum them in the way you are wanting.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
