ExcelBanter - More Averaging

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - More Averaging (https://www.excelbanter.com/excel-worksheet-functions/8462-more-averaging.html)

Reggie

More Averaging

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

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

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

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

.

All times are GMT +1. The time now is 07:20 PM.