AverageIF- Date range and multiple criteria from SS source

BBIrr41

Hi,

I keep getting unparceable, please help!

Need the average of all days in source 1that meet this criteria: source 2 ="closed", and source 3 has a date range of 1/1/21-3/31/21.

Source 1-{Tracker Range 8}

Source 2- {Tracker Range 4}

Source 3- {Tracker Range 3}

Mike TV

@BBIrr41

Try this:

=AVG(COLLECT({Source 1}, {Source 2}, "Closed", {Source 3}, >=DATE(2021, 1, 1), {Source 3}, <=DATE(2021, 3, 31)))

Mike TV

@BBIrr41

What type of column is Source 1? The AVERAGEIF function works on numbers. If that column is a date, it won't work on it. What would an average of a date even be? What's your expected result?

BBIrr41

@Mike TV Yes source 1 is numbers, its count of days containing a separate formula, but this column has some blanks so may need IFBLANK too.

Mike TV

@BBIrr41

Try this:

=AVG(COLLECT({Source 1}, {Source 2}, "Closed", {Source 3}, >=DATE(2021, 1, 1), {Source 3}, <=DATE(2021, 3, 31)))

BBIrr41

@Mike TV Thanks!! It worked!