Average of select range of numbers

  • Thread starter Thread starter W Palermo
  • Start date Start date
W

W Palermo

I need help to average a set of numbers in a column based on the data in
another column. Example:
c35=45%, c36=55%, c37=65%, c38=75%
d35=2.2, d36=2.3, d37=2.4, d38=2.5
I want to average the numbers in d column only if corresponding number in c
column is = or >50% and = or<70% ignoring zero or blank cells.
Appreciate any help!
 
Maybe something along these lines could help. I am assuming that your data
stops
at row 38
I would put this into Column E35 and drag down to cell E38
=IF(AND(C35>=50%,C35<=70%),D35,"")
I would put this into E39
=AVERAGE(E35:E38)
 
Try this array formula** :

=AVERAGE(IF((C35:C38>=50%)*(C35:C38<=70%),D35:D38))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 
Back
Top