Forum Discussion
Calculate more than 30 items in a single formula
I have hit the wall several times. They at least could tell you when it errors out. No, you lose all your data and keep fighting. ccomins
rpotter ccomins Yes, SUM function takes up to 30 columns/arguments only. This is by design limitation in SharePoint formulas.
So, you can use the nested SUM functions or the SUM function with addition ( + ) like:
=SUM(SUM([Col],[Col],[Co3]),SUM([Co31],[Co32],[Co33]))
In 1st nested SUM() you can use [Col1] to [Col30] and 2nd nested SUM() you can use [Col31] to [Col55].
OR
=SUM([Col],[Col],[Co3])+SUM([Co31],[Co32],[Co33])
In 1st SUM() you can use [Col1] to [Col30] and 2nd SUM() you can use [Col31] to [Col55].
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.
Thank you this helps! ganeshsanap