I would like to have something like this, where AnnualSales is automatically populated with the sum of the four quarter sales figures:

Q1Sales     Q2Sales     Q3Sales     Q4Sales    AnnualSales
-------     -------     -------     -------    -----------
 123.12      234.23      345.34      456.45    =sum(Q1Sales, Q2Sales, Q3Sales, Q4Sales)

Is this possible with OOTB functionality, or must I find another way of achieving this?

2 Answers 2


According to your description, it seems you need to use a calculated column. The settings is like the screenshot below. In my test list, it works properly. enter image description here

enter image description here

  • Thank you so much for this screenshot! I'd made the column a Number, not noticing the Calculated column type. This now works exactly as I want it to! Thanks again.
    – pwmusic
    May 1, 2020 at 7:33
  • @user3761 Glad to be help. You can mark it as answer if it solves your issue.
    – Jerry_MSFT
    May 1, 2020 at 7:58

Please consider using a calculated column. You can either use the addition operator (+) or the SUM function. Please refer to this Microsoft article for details.

enter image description here

  • Thank you for answering so quickly! Unfortunately, I'm not seeing the result of the calculation. I stripped it back to 'Default value: Calculated Value' '=SUM(1,2,3,4,5)' but the column remains unpopulated. Could you tell me whether I need to do something else to get it to automatically calculate and display the value, please?
    – pwmusic
    Apr 30, 2020 at 18:30
  • Can you post a screen shot of your list and the calculated column settings.
    – UBK
    Apr 30, 2020 at 18:39
  • Another item to remember that the calculated values are only updated when an Item changes. So, try updating the list item and see it that populated the calculated column.
    – UBK
    Apr 30, 2020 at 18:49
  • Thank you for help and questions last night. I appreciate you taking the time to help.
    – pwmusic
    May 1, 2020 at 15:38
  • If it helped you please consider up voting the post and/or mark as answer.
    – UBK
    May 1, 2020 at 15:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.