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)
"W Palermo" wrote:

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!