I am using SharePoint Modern. Can I display only sum value of selected column from List on Page? I do not want to show all the List Item. Best is to show as a textbox in Page

  • There is no SharePoint out of the box web part to achieve this. Jul 21, 2021 at 7:48
  • Any workaround available on this?
    – James
    Jul 21, 2021 at 9:32
  • Create simple app using Power Apps to show the count/sum OR develop simple SPFx web part (This will help for longer run as you can make if configurable to select list & list columns from web part properties). Jul 21, 2021 at 10:14
  • I am quite new to SharePoint. As far as I can see from my SharePoint, I dont see any access to SPFx or SharePoint Designer, though I am admin of the site. May I ask, How can I achieve that?
    – James
    Jul 21, 2021 at 22:53

1 Answer 1


If the selected column is a number column, you could use OOTB sum function. enter image description here

As a workaround, you could open the list in the excel, then calculate in the excel.




Display column sum in the other page by using scripts. https://stackoverflow.com/questions/58890560/sum-of-sharepoint-list-items-in-particular-field https://social.msdn.microsoft.com/Forums/office/en-US/3ef7d887-9fa3-416c-9350-520bb2b1df4a/camlquery-to-display-calculated-column-total?forum=sharepointdevelopment

  • Thanks for the advice. I am looking for just extract the sum value, so that I can display the value in a label or box form (part of dashboard) in the modern Page.
    – James
    Jul 24, 2021 at 2:12
  • Per my knowledge, there's no OOTB way to achieve this. Jul 26, 2021 at 10:10
  • Any workaround or alternative ways to achieve? Or maybe some script?
    – James
    Jul 26, 2021 at 12:20
  • I have updated the answer, please check. Jul 27, 2021 at 10:37
  • Will the script applicable in SharePoint modern page?
    – James
    Jul 28, 2021 at 13:54

Your Answer

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

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