Sum of a Single Column in Sharepoint

Posted on 2011-10-24
Last Modified: 2012-06-08
i have a column that is a number field in sharepoint list "Number of hours" that contains full numbers, how do i get the total hours
if the Column is: Number of Hours




total must display 41 not 3

Question by:tapiwab
    LVL 11

    Accepted Solution

    You can use the list view settings and set to view a total "Sum" of this column.
    Just enter "Modify this view" link in the "Views" dropdown and under totals where you should see the name of your column choose "Sum".
    I hope it helps.
    LVL 5

    Author Comment

    that doesnt work because it count number of row not adding actual numbers in the column
    LVL 5

    Author Comment

    that does work because it count number of row not the actual number in the column
    LVL 11

    Expert Comment

    If you see only a "Count" option near your column name in the "Totals' section it means that your column is not a "Numbers" column. Please re-check againg the column type.

    About "Totals" from

    Totals    Displays summary calculations for the columns in the view, such as: count, average, maximum, minimum. By setting the title column to Count in a document library, for example, the view will display the number of documents in the view and in the groups in the view.
    The columns that are available for totals and the settings available for each column differs depending on the type of column, such as number, and the type of list or library the view is being created for.

    In any case you always can show it using SharePoint Designer.
    Please follow this article (it works the same way even for non calculated columns):
    LVL 5

    Author Comment

    the problem is my columns where created with information from Infopath fields so after publishing the form all fields became single line of text, now i cant see sum

    i will try the dataview part solution
    LVL 11

    Assisted Solution

    And you can't change the promoted field during republish?
    You can create a new numeric column in your form library and target your form field (in the form during the publish procedure) to this new field. But if you have a lot of existing forms it's a little bit risky.

    So the simplest solution in your case is to create a new numeric column and update it to a value from the source column(that cames from infopath) using a Workflow.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SharePoint 2013 Patch Path 5 30
    Excel Array formula Help 11 42
    Excel won't allow to break links... 4 38
    SharePoint JSOM error 7 33
    I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
    We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
    Viewers will learn how to apply various conditional formatting in Excel 2013.
    Video by: Zack
    Viewers will learn about using Excel in a browser with Excel Online.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now