Forum Discussion
DBreezy92
Dec 10, 2021Copper Contributor
Sharepoint Calculated Columns
Hi, hopefully this is the correct forum to help. I have a sharepoint site which has 5 columns of data which captures different financial amounts, I am looking to created a calculated column on shar...
ganeshsanap
Dec 12, 2021MVP
DBreezy92 To add numbers in two or more columns in a row, use the addition operator (+) or the SUM function.
Examples:
=[Column1]+[Column2]+[Column3]
OR
=SUM([Column1],[Column2],[Column3])
To subtract numbers in two or more columns in a row, use the subtraction operator (-) or the SUM function with negative numbers.
=[Column1]-[Column2]
OR
=SUM([Column1], [Column2], [Column3])
For more information, check this documentation: Calculated Field Formulas - Mathematical formulas
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.