AVGIF Formula Based on Date Range


Hello everyone,

I'm trying to get a average of a column if the cells in another column are within 90 days of today.

My current formula is =AVERAGEIF([Pick-up Variance]:[Pick-up Variance], [Pick-up Date]@row>TODAY(-90)).

I tried using AVG(Collect) as well with no luck.

=AVG(COLLECT([Pick-up Variance]:[Pick-up Variance], [Pick-up Date]:[Pick-up Date], , but I'm getting a Invalid Operation.'


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!