Forum Discussion

Copper Contributor

Jul 02, 2019

Calculate more than 30 items in a single formula

I have created a sharepoint list for work where I would like to get the SUM of 55 columns, however, it seems sharepoint online does not like formulas with more than 30 items. I have resorted to creat...

Copper Contributor

Aug 21, 2023

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

ganeshsanap
MVP
Aug 22, 2023
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.
- rpotter
  Copper Contributor
  Aug 22, 2023
  Thank you this helps! ganeshsanap