How can I calculate the average of the values over a period of time?

Victor.Silva

I have two databases, one with the values and dates, and the second to create a more succinct report with just the average of the values in database 1 for each month of the year, but I can't find a formula to help me with this.  Does anyone have a solution for a similar case? I need the calculated average to be like "Calculate the average of the values if >= 01/Jan and <=01/Feb.

John C Murray

Hi Victor,

there is an AVERAGEIF function which might get you across the line.

https://help.smartsheet.com/function/averageif

I would suggest creating a new column named "Month" to simplify things. Create a column formula to extract the month value:

=MONTH([Date]@row)

Then you can calculate the averages. This example is for January:

=AVERAGEIF([Month]:[Month], 1, [Value]:[Value])

I hope that helps