Average of select range of numbers
 

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!

Average of select range of numbers
 

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!

Average of select range of numbers
 

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)

--
Biff
Microsoft Excel MVP


"W Palermo" wrote in message
...
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!