SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a calculated column in a list and I would like to get a sum of that column in the view. I can't use datasheet view, and I don't like the idea of a workflow because the user only sees a few records that are being summed. Any suggestions?

share|improve this question
What are you using to view your data? Data View Web Part? How are you filtering the records being shown to the user? – Jim Bob Howard Apr 24 '12 at 4:05

I hate bubbling old topics up, but I ran across this thread today and noticed it had lots of views and no answers.

A really simple way to do this is to create a workflow that runs automatically on new/edit list items and all it does is copy the calculated value to a "normal" number column and then sum that column in the view.

share|improve this answer
That would be my preferred approach - I know the OP said they wanted to avoid workflows - but that may not be a wise decision when this is something that just works out of the box. Only thing I'd add is that if you use a workflow, the calculated column may not be needed in the first place – PerryW Aug 12 '15 at 1:29

If you are using a SharePoint data view you can display the count of a column using XSL

< xsl:value-of select="sum(/dsQueryResponse/Rows/Row/@ColumnName)" />  
share|improve this answer

I don t there is a direct way to do this. Please check the link below.I hope this would help.

share|improve this answer
this one refers to SharePoint Designer 2007, and the menu structure is quite different in 2010... – Mark Latture Dec 1 '11 at 15:14

Can you check this post and get some idea?

share|improve this answer
This one is also an SP2007 post. – Mark Latture Dec 5 '11 at 18:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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