I see option to calculate total of the columns but not row.. I don't have access to sharepoint designer well.. is there anyway to do it through front-end..

Ex: 50 50 = 100 (I know this is possible)
168 (not able to do this)enter image description here


Assuming you have Field1, Field2, Field3 - all numeric.

To have a Field4 that sums a row, use calculated column with =SUM(...) function.

To have a pseudo-row that sums a column, modify the view to enable totals. This will not work with calculated columns.


Update view and use the total option to sum the values in a column.

  • I tried that and not working as well? – Hindraftv Mar 15 '16 at 15:46
  • Is project total a calculated field? – Amal Hashim Mar 15 '16 at 15:59
  • yes project total calculated, if you look at the screenshot the sum for project total not getting calculated – Hindraftv Mar 15 '16 at 16:10
  • Ok in that case you need to use a workflow to put calculated value in a numeric field and use total on that field. Another option include using CSR or CSOM. – Amal Hashim Mar 15 '16 at 16:13
  • How do I use workflow? – Hindraftv Mar 15 '16 at 16:15

In order to make a workflow I would recommend downloading sharepoint designer. Then load up the site you are trying to change and create a list workflow for the list you are trying to manipulate. Use workflow variables in a looping structure to loop through the columns in the row and sum the totals.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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