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.
Answers

Hi Victor,
there is an AVERAGEIF function which might get you across the line.
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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!