AVERAGEIF returning 0
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]
Help Article Resources
Check out the Formula Handbook template!