AVERAGEIFS Function using 2 criterias?

[pgp007]

Hi All,

I am trying to average large amounts of data (daily prices for 5 years) by year and month. I see the AVERAGEIFS function is limited to using 1 crieria to sort and average the data. i.e month or year

I was wondering if there was a function or a work around to first look at the data by year and then average by month. Maybe combining formulas??

I have organized the data appropriately in the spreadsheet attached.

Many Thanks to All!

[FDibbins]

I see the AVERAGEIFS function is limited to using 1 crieria to sort and average the data. i.e month or year

Not so, averageifS() can take multiple criteria

[FDibbins]

perhaps this?
=AVERAGEIFS($F:$F,$B:$B,I$17,$C:$C,I18)

[FDibbins]

Here is that same formula without the need for the helper colimns in B:D...
=AVERAGEIFS(F:F,$E:$E,">="&DATE(I$17,I18,1),$E:$E,"<"&EDATE(DATE(I$17,I18,1),1))

[pgp007]

Thanks a lot Ford it worked! Really appreciate your help...