Average if with grouping

[santhoshkunder]

Please help me achieve this!

Name	Month	Sal	Average
ABC	Jan	2
ABC	Feb	4
ABC	Mar	6	4
XYZ	Jan	5
XYZ	Feb	10
XYZ	Mar	15	10

 

[ETAF]

=IFERROR(IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$7,A2),AVERAGEIF($A$2:$A$7,A2,$C$2:$C$7),""),"")

 

[santhoshkunder]

=IFERROR(IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$7,A2),AVERAGEIF($A$2:$A$7,A2,$C$2:$C$7),""),"")

You are a genius!

 

[ETAF]

you are welcome

 

[shrivallabha]

Another option you can try is SUBTOTAL through outline.
1. Select Range for which you need SUBTOTAL (AVERAGE)


2. Choose Data >> Outline >> Subtotal


3. Choose settings as below


4. Output will appear as below. Excel will insert required rows. Bold ones in the snapshot below.