• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Average if with grouping

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

Attachments

  • Averageif-ETAF.xlsx
    9.4 KB · Views: 3
Another option you can try is SUBTOTAL through outline.
1. Select Range for which you need SUBTOTAL (AVERAGE)
83399

2. Choose Data >> Outline >> Subtotal
83400

3. Choose settings as below
83401

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