试试这个:=AVERAGEIF($A$2:$A$13,A2,$C$2:$C$13)

Try this: =AVERAGEIF($A$2:$A$13,A2,$C$2:$C$13)

这应该在每个单元格的 B 列(QR 平均值)中.当然中间的参数会自动改变.

That should go in column B (QR Average) in each cell. The middle param will automatically change, of course.