Forum Discussion

Kyle_Chesshir's avatar
Kyle_Chesshir
Copper Contributor
May 16, 2024

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 se...
developer
SharePoint Online
sharepoint server
Rob_Elliott's avatar
Rob_Elliott
Bronze Contributor
May 16, 2024

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)

Kyle_Chesshir's avatar
Kyle_Chesshir
Copper Contributor
May 16, 2024
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)?
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    May 16, 2024

    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)

Resources