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/
Jennifer_Wilson
Feb 27, 2023Brass Contributor
Under 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/
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/
parentsqueries
Mar 01, 2023Copper Contributor
Jennifer_Wilson Thanks!