locked
Sum of a Single Column in Sharepoint RRS feed

  • Question

  • i want to sum up number of Hours Column that i have in my SharePoint site , does anyone know how to sum up a single column ,I am using MOSS2007.
    SK
    • Moved by Mike Walsh FIN Friday, July 16, 2010 2:58 AM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Thursday, July 15, 2010 2:31 PM

Answers

  • Edit the view, one of the options (towards the bottom, that are usually collapsed) under Fiilters and groups etc is an option to 'SUM' or 'TOTAL' etc.

    Your then be able to 'SUM' the columns placing the value at the top of the view.


    Regards, Aaron www.aaron-rendell.co.uk
    Thursday, July 15, 2010 3:24 PM
  • I am Done with calculating the total using the Data Sheet View;-)
    SK
    • Marked as answer by Karthik.S Friday, July 16, 2010 1:04 PM
    Friday, July 16, 2010 1:04 PM

All replies

  • Edit the view, one of the options (towards the bottom, that are usually collapsed) under Fiilters and groups etc is an option to 'SUM' or 'TOTAL' etc.

    Your then be able to 'SUM' the columns placing the value at the top of the view.


    Regards, Aaron www.aaron-rendell.co.uk
    Thursday, July 15, 2010 3:24 PM
  • I dont need the count the number of entries , but to  sum of all values in the coulmn

    eg:

    if the Column is: Number of Hours

                            16

                            14

                            11

    I dont need the answer '3' that is the count of the entries ,but i need '41' the SUM of All the Entries..................


    SK
    Friday, July 16, 2010 4:11 AM
  • I am Done with calculating the total using the Data Sheet View;-)
    SK
    • Marked as answer by Karthik.S Friday, July 16, 2010 1:04 PM
    Friday, July 16, 2010 1:04 PM