More Averaging

[Reggie]

Hello,

I'm using the following formula in a spreadsheet I'm
working on:

=ROUND(AVERAGE(IF((L47:L75>=C27)*
(L47:L75<=D27),L47:L75)),0)

I would like to throw one more criteria into the mix. I
want the average, within the range specified, if a value
criteria in yet another column is matched.

Any ideas?

Thanks,

Reg

 

[Jason Morin]

=ROUND(AVERAGE(IF((L47:L75>=C27)*
(L47:L75<=D27)*(M47:M75=E27),L47:L75)),0)

HTH
Jason
Atlanta, GA

 

[Reggie]

Wow. You are an Excel GOD!

Thanks,
Reg

-----Original Message-----
=ROUND(AVERAGE(IF((L47:L75>=C27)*
(L47:L75<=D27)*(M47:M75=E27),L47:L75)),0)

HTH
Jason
Atlanta, GA

.