Average Cells Based on Month and Other Criteria

[kr11]

Hey all!

I'm sure I'm missing something obvious, but I can't get this average to work. I want to do an average of some cells based on their month and another criteria. I attached an example of what I was trying to do. I was trying to get an average of column C for the month of January based on Apples or Oranges. Can anyone shed some light?


Apples&Oranges.xlsx

[benishiryo]

hi kr11, welcome to the forum. in Excel 2007, you can try AVERAGEIFS in G3:
=AVERAGEIFS($C$1:$C$36,$A$1:$A$36,1,$D$1:$D$36,F3)

in older versions:
=SUMPRODUCT(($A$1:$A$36=1)*($D$1:$D$36=F3),$C$1:$C$36)/SUMPRODUCT(($A$1:$A$36=1)*($D$1:$D$36=F3))

extend the range as you desire

[kr11]

Hey benishyiryo! Thanks for the welcome!

I forgot to mention, the problem is that the data is updated automatically and very frequently. I was hoping to use a formula that would update the averages automatically, instead of me going in and readjusting the ranges every day. Any thoughts? Thanks!

[etaf]

this will work for Month 1
=AVERAGEIFS($C$1:$C$36,$A$1:$A$36,1,$D$1:$D$36,F3)

change the 1 to a 2 for feb
or use another cells to put the 1 or 2 into