# Using AVERAGE within nested IF function (or vice versa)

#### joermoss

##### New Member
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.

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
=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.

Thanks very much.

Replies
0
Views
955
Replies
3
Views
707
Replies
4
Views
332
Replies
7
Views
336
Replies
19
Views
2K

1,216,086
Messages
6,128,734
Members
449,466
Latest member
Peter Juhnke

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back