AVG formula and Invalid Data Error

kioshi43

Hello,

I seem to have hit a bit of a pickle (or an afternoon brain fart) while trying to create a roll up.

Essentially what I'm trying to do is create a roll up of averages by month and my formula is returning an Invalid Data Error. I checked the reference columns and they are indeed date columns but beyond that, it should be pretty straight forward:

=AVG(COLLECT({Assigned People}, {Target Date}, MONTH(@cell) = Month@row))

Is there something glaringly obvious that I'm missing?

Leibel S

What is in the assigned people column?

kioshi43

It's a column that has the number of people assigned

Leibel S

@kioshi43

Try adding IFERROR around the MONTH() function.

=AVG(COLLECT({Assigned People}, {Target Date}, IFERROR(MONTH(@cell),0) = Month@row))

If any of your dates are not actual dates then it will result in an error