Averageif within a date range

malorie

I am trying to get the average cost of contracts written within each month of the year.

=AVERAGEIF({R2 Scheduled Date}, AND(@cell >= Feb2, @cell <= Feb3), {Total Gross}) is returning "$0.00"

Any suggestions?

malorie

Also have tried the following but I am only getting a #UNPARSEALE error in response.

=AVG(COLLECT({Total Gross}, {R2 Scheduled Date}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024))))

KPH

Hi @malorie

You almost had it with your second formula. Just remove the final parenthesis.

=AVG(COLLECT({Total Gross}, {R2 Scheduled Date}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024)))