4

I would like to know how can I can sum the values of a specific column across multiple rows in a list. For example:

enter image description here

I have 3 rows of camera entries and 2 rows of keyboard entries. I would like create a new column with the sum of these rows. How can I achieve this?

6

You can use 'Group By' to group (and sum) your Keyboard rows and your Camera rows.

Go in List Settings>Modify View>scroll down to 'Group By' and select 'Hardware Type' as the value.

You might also want to use 'Totals'. Go in List Settings>Modify View>Totals>choose a field to total by e.g. Hardware Type. You can also use Filters to filter on one Hardware Type if you wish.

0

You can use View with Group and then Sum by column you need.

0

Following are some of the solutions which you can implement for getting sum

  1. Most easy solution is on the ribbon tab select Modify View. Scroll down and expand Totals section. Select Sum and select the column for which you need to apply sum and save the view. You can use it together with groups.

  2. Other solution is to use Calculated columns

https://www.metrostarsystems.com/enterprise-it/sharepoint-calculated-column-total/

  • Thanks for all your answers. Is there way to create separate column with sum of all Hardware Type? – Alex Dec 19 '17 at 12:19
  • Yes indeed this is also found in the Totals section of a view. Simply choose "Count" as your option and it will count the data in any given column. Filtering on your data will cause the number to display the total number of items filtered in that column. – Chris G Dec 19 '17 at 15:50
0

Modify your view and see the Total section to turn the sum option on. (note your column needs to be a number type). you can also group by the other columns to get the sums that are grouped by a specified type.

enter image description here

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.