AVERAGE IF for a range?

[gummybears]

So what I need to do is find the average premium for a certain insurance policies. So for example, for under age 57, I just use =AVERAGEIF(cells with ages, "<57", premiums) but now I need to find it for a premium of ages 58-75, so how would I write the criteria?

[daddylonglegs]

You can use AVERAGEIFS like this

=AVERAGEIFS(premiums,cells with ages,">=58",cells with ages,"<=75")

[Pete_UK]

Try it this way:

=AVERAGEIFS(premiums, cells with ages, ">57", cells with ages, "<=75")

Note that the syntax for AVERAGEIFS is slightly different than for AVERAGEIF - the first parameter is for the range you want to average, then you have pairs of range_for_condition and the condition itself, which are ANDed together.

Hope this helps.

Pete

[mcmahobt]

AVERAGEIFS lets you add in more than one criteria:

=AVERAGEIFS(premiums,cells with ages,">=58",cells with ages,"<75")

Will that work?

[gummybears]

Thank you!