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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!