Average with grouping

Question

Please help me achieve the average!

Name	Month	Sal	Average
ABC	JAN	2
ABC	FEB	4
ABC	MAR	6	4
XYZ	JAN	5
XYZ	FEB	10
XYZ	MAR	15	10

Answer 1

Hi @Kunder, Santhosha SBOBNG-PTIV/ES,

Try this formula:

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

Hope it's helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.