I need to calculate the average of a number field called "Total" over a date range. I have a To and From date picker.

I'm sure this can be done in Sharepoint, but I have no idea of the logic to use.

Can anyone out there help me?

By the way, we are using Office365 Sharepoint.


Jeff Bolin

  • You want to create a calculated column using multiple list items data? If Yes, this is not possible. Calculated column can access the data of only single list item/row. – Ganesh Sanap Aug 14 '19 at 16:46
  • So, a total cannot be averaged over a date span? – Mr Bangus Aug 14 '19 at 16:53
  • Using Out of the box calculated column, it is not possible. – Ganesh Sanap Aug 14 '19 at 16:54
  • Are you trying to get the total from multiple list items? Correct me if I am misunderstanding anything. – Ganesh Sanap Aug 14 '19 at 16:55
  • Just one field title "Total". But I need this total to be averaged over a date span for a final averaged total. – Mr Bangus Aug 14 '19 at 16:56

To average over a date column, modify view->in Totals section, choose Average for the date column:

enter image description here

| improve this answer | |
  • Thanks Lisa. Doesn't this average the entire list though? I guess what I'm needing is some custom coding. We've started using Sharepoint in Office 365 not long ago. We were using Sharepoint 2010 on one of our local servers. We had an Excel guru who actually made an Excel spreadsheet that pulled data from a Sharepoint list. The data was for example, (Employees name, Total Score, To Date, From Date). And once it pulls all of the scores for that employee, it will give an average of their personal scores. Would be nice if MS expanded Sharepoint's calculated field abilities. – Mr Bangus Aug 15 '19 at 12:26

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.