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

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.

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

-----Original Message-----
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
.

.