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.
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.