Using AVERAGE within nested IF function (or vice versa)

[joermoss]

I'm a relative beginner to Excel, and I can't make this work.
I have a large spreadsheet, and in M2:M584 are values descending from 114 down to 47.
I need a formula to compute the average in Column D only for those rows in Column M with values between 80 and 89.
Any help would be greatly appreciated. Surely this can't be rocket science.

 

[Aladin Akyurek]

=AVERAGE(IF($M$2:$M$584 >= 80, IF($M$2:$M$584 <= 89, $D$2:$D$584)))

which you need to confirm with control+shift+enter, not just with enter.

 

[joermoss]

Thanks very much.