AverageIf multiple conditions

[WorkMan]

Hi Excel Gods-

I currently have this equation:

=AVERAGEIF($B$2:$B$900000,">="&L5,$C$2:$C$900000)

Where L5 = 100

I'm interested in having the formula averageif B column value is between L5 & L6.

Where L6 = 200

So I want it to find all values in B$ that are between >= 100 but < 200, and then average their C$ counterparts.

What's the best way to do something like this?

Thanks!

[NBVC]

Try:

=AVERAGEIFS($C$2:$C$900000,$B$2:$B$900000,">="&L5,$B$2:$B$900000,"<="&L6)

[WorkMan]

Perfect! Maybe someone could explain to me why that works?

[NBVC]

Have you looked at AVERAGEIFS help in EXCEL Help?

it allows multiple conditions..

The first range is the averaging range, the next items are criteria ranges and criteria for each condition to be met.