averaging conditions

[newbie2]

Hi,

I would like to average a set of number within a range of age. I have in column a the age from 0-25, column B is the weight. I like to know what is the average weight for individuals from 3 to 5. I used =+AVERAGEIFS($B$3:$B$25,$A$3:$A$25,B64); B64 is the age criteria which is <=5. The results I get is an average of all weight from 0-5.

thanks
newbie2

 

[m.k.johnson86]

Hey,

I would do it the long way and in coloumn C insert if statement saying anybody over the age of "X" bring back weight then in coloumn D insert one saying younger then "Y" and in E have the if statement saying if there is a value in both use the information. Hope that helps but if anybody knows a better way ild love to know

Regards,
Newbie2011

 

[T. Valko]

Hi,

I would like to average a set of number within a range of age. I have in column a the age from 0-25, column B is the weight. I like to know what is the average weight for individuals from 3 to 5. I used =+AVERAGEIFS($B$3:$B$25,$A$3:$A$25,B64); B64 is the age criteria which is <=5. The results I get is an average of all weight from 0-5.

thanks
newbie2

You have to define both ends of the age criteria since you also have ages less than 3.

Like this:

=AVERAGEIFS($B$3:$B$25,$A$3:$A$25,">=3",$A$3:$A$25,"<=5")

If you use cells to hold the age criteria:

• X1 = 3
• X2 = 5

=AVERAGEIFS($B$3:$B$25,$A$3:$A$25,">="&X1,$A$3:$A$25,"<="&X2)

 

[newbie2]

Thanks....this is very helpful and it works

 

[T. Valko]

Thanks....this is very helpful and it works

You're welcome. Thanks for the feedback!