I would like to know how can I can sum rows in a list. For example - please see attached file.
I have 3 rows of cameras and 2 rows of keyboards. I would like create a new column with the sum of these rows. How can I achieve this?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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.
Following are some of the solutions which you can implement for getting sum
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.
Other solution is to use Calculated columns