Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How do I calculate column averages?

  Asked By: Bob    Date: Jan 29    Category: Sharepoint    Views: 9153

Is there a way to calculate the average value of a column in a
SharePoint table? The column contains numbers obviously. Even if it
takes some sort of third-party SharePoint application.

Ideally, we are trying to duplicate the functionality of an Excel
sheet that has many different sets of data on each worksheet, with an
average of each number set in the same sheet. I know duplicating this
exactly is either impossible or very hard, but that is kinda the target.



4 Answers Found

Answer #1    Answered By: Darrius Whitfield     Answered On: Jan 29

Sort of. Create a view, make sure the column  to be averaged is included.
At the bottom of the view definition, in the Totals section, select the
column, and select the Average option.

The view will display the average, but the caveat is that it will only
display the average of the items displayed on the page. So if you have
1000 items in your list, and the view only displays 100 items at a time,
the average will be for those 100 items.

Answer #2    Answered By: Adrienne Greene     Answered On: Jan 29

Thanks for your answer, but I forgot to mention that I also wish to
graph the averages of the columns if possible. Sorry I didn't mention
it earlier. Your solution doesn't allow me to graph them.

I'm trying to use the PivotChart graph webpart, but it won't work.
Does anyone know of a graphing webpart that would graph the average
values of columns in a table?

Answer #3    Answered By: Joshuah Huber     Answered On: Jan 29

I found out how to do what I wanted. I did not know about the Office
Spreadsheet web part, and I found using that in conjunction with the
PivotChart works nicely.

Answer #4    Answered By: Laura Walker     Answered On: Jan 29

Look at the Totals section of any List View. It provides aggregates like
Count, Min, Max, Avg, etc. based upon the datatype of each column  in the

Didn't find what you were looking for? Find more on How do I calculate column averages? Or get search suggestion and latest updates.