Averages - Help

  • Thread starter Thread starter Rose Davis
  • Start date Start date
R

Rose Davis

Can anyone help with this. I have 1 column with 1000 rows and need to
determine the average of each row that is greater than 95 and less than 95,
but I also need to identify the row that is greater than 95 =R and less than
95 = NR I am not able to sort the row. The information needs to stay in the
current order.

88.1042 NR average amt
88.8367 NR average amt
92.1021
88.7146
94.1467
91.7664
88.8367
92.3157
96.8933 R average amt
95.7031
94.9707
96.5576
99.7925
99.8535
98.9075
102.1423
102.8137
101.8066
102.2644
102.478
102.7527
 
Hi Rose,

Assuming your numeric values are in Column A and your NR's and R's are
in Column B, try,

Greater than 95
=AVERAGE(IF(A1:A21>95,A1:A21))

Greater than 95 =R
=AVERAGE(IF((A1:A21>95)*(B1:B21="R"),A1:A21))

Less than 95 =NR
=AVERAGE(IF((A1:A21<95)*(B1:B21="NR"),A1:A21))

These formulas need to be entered using CTRL+SHIFT+ENTER.

Hopefully, this is what you're looking for!
 
Back
Top