AVERAGEIF returning 0

Hi all,


I'm trying to create an AVERAGEIF formula to achieve the following:


If the "start date" column shows a date from the previous month, then average the numbers in column "Q1"


No matter what I try to do, I keep producing the result of 0. Can anyone advise on how to do this?


I would have thought it would be something like:


AVERAGEIF([start date]:[start date], IFERROR(MONTH(@cell), 0) = IFERROR(MONTH(TODAY()) - 1, 12), [Q1]:[Q1]

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!