Forum Discussion
Faldo
Feb 27, 2023Copper Contributor
Sum a sharepoint list column
Hi I would like to sum a number column using a method that I can then use that sum with another column sum and subtract one from the other. I have used the built in method but cant access the value...
- Feb 27, 2023Under the "Columns" section, click on "Create column".
Enter a name for your calculated column and select "Calculated" as the column type.
In the "Formula" section, enter the following formula:
=[Column1]+[Column2]-[Column3]
You can find the more here:
https://microsoft365.today/sharepoint-formulas-for-calculated-fields/
RobElliott
Feb 27, 2023Silver Contributor
Faldo you can't do calculations based on the sum of different columns. Apart from using a calculate column on each item as suggested by Jennifer_Wilson which is the solution I would use, the only other method is to build a flow in Power Automate to loop through all the items, add the number of each one to a variable then update another column with the overall result of that variable.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Faldo
Feb 28, 2023Copper Contributor
Thanks for replies.
Not quite sure im getting it right. Im trying to sum up a complete column say credits and a column debits and subtract debits from credits to get a balance.
- RobElliottMar 01, 2023Silver Contributor
Faldo yes we know, but with SharePoint you can't do that which is why there need to be workarounds.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- FaldoMar 01, 2023Copper Contributor