Google Sheets Formula Help with Average of One Column for Values that Match Another

[truenw]

I would like to find a way to

In Column P, I would like to display the average of all Rows that show a matching date value for Column G, but to pull the average range from row N.

So...lets say, I have Rows 1, 2, 3, 4, 5 and in 1, 2, 4, the date in G is 4/1/20, then in rows 3 and 5, the date in G is 4/3/20. In column P, for each row, I want it to detect the date in G, then average the values in column N for all columns with a matching date value.

 

[jasonb75]

The google formula for that should be the same as the excel formula, assuming data starts in row 2, enter this into P2 and fill down.

=AVERAGEIF(G:G,G2,N:N)

 

[truenw]

@jasonb75 Thank you so much! That helped me out a lot