1

Created a custom list in SharePoint 2013. I have a column that is full of numbers. I would like to find the average per column. To solve this issue I created a calculated column and applied this formula (see below) But it's not working. Is it possible to add the numbers in a column to find the average similar to excel?

 =AVERAGE([Column1])
3
  • You want the average at the bottom of a column, or multiple columns in one row averaged together?
    – Erin L
    Apr 11, 2016 at 20:57
  • @ErinL Sorry for not being clear in my question. If possible, I would like the average at the bottom of the column. Thanks for your help Apr 12, 2016 at 11:29
  • The second option in my post below gives instructions for that. The average will be at the top of the view.
    – Erin L
    Apr 12, 2016 at 12:55

1 Answer 1

10

To average multiple columns in an item, you'd use a calculated column such as =AVERAGE([Column1],[Column2],[Column3]).

To average a column, edit the view and expand the Totals section. By your column name, if it's a number, you can select average (etc) from the dropdown.

2
  • I am assuming if you are trying to average from a column that has a formula (calculated column) attached the 'Total' option will not work, correct? Apr 12, 2016 at 14:33
  • That's correct.
    – Erin L
    Apr 12, 2016 at 14:39

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.