Average of Average when a condition is met

[prazad82]

Hello,


http://www.2shared.com/file/sRVwNiyj/book1.html


In table1, I need to get the average scores of each teams.


Thanks

 

[keymaster]

Hi Prazad... you can use AVERAGEIF for this. In C7 write,


=AVERAGEIF($J$5:$J$13,$B7,K$5:K$13)


and drag it down and sideways to get what you want.

 

[kaushik03]

Hi prazad82,


Try this at C7:


=AVERAGEIF($J$5:$J$13,"="&$B7,K$5:K$13)


Copy the same down and across.


Kaushik

 

[kaushik03]

OOps...I did not see...sorry Chandoo..probably your post comes in when I was working....


Kaushik

 

[prazad82]

Thank you Chandoo and Kaushik. Both the formulas worked!


Kaushik, could you please tell me the use of "="&$B7 in a formula?

 

[Kevin@Radstock]

@ prazad82


"Kaushik, could you please tell me the use of "="&$B7 in a formula?"


Basically, You don't need it! Use Chandoo formula.

 

[Faseeh]

@prazad82,


People usually do this to add a criteria when using SUMIF(),COUNTIF(),AVERAGEIF(). you can use other operates as well like,">","<","<>" etc.


Regards,

 

[prazad82]

Thanks Faseeh

 

[NARAYANK991]

Hi Prazad ,


You can find a detailed explanation here :


http://colinlegg.wordpress.com/2012/04/06/sumif-formulas/


Narayan