求助公式，周期内多个省份的得分平均数及得分次数

勒新斯斩什么

求助大神：
周期内，江苏省和湖南省的打分次数和平均分，求I列和J列的公式，已上传附件

ww87725244

=SUM(COUNTIFS($C$2:$C$207,H4,$D$2:$D$207,{"江苏省","湖南省"}))
=AVERAGE(AVERAGEIFS($B$2:$B$207,$C$2:$C$207,H4,$D$2:$D$207,{"江苏省","湖南省"}))

ovxyz

=SUM(COUNTIFS(D:D,{"江苏省","湖南省"},C:C,H4))
=SUM(SUMIFS(B:B,D:D,{"江苏省","湖南省"},C:C,H4))/I4

你是那块小饼干

1. =GROUPBY(C2:C207,B2:B207,HSTACK(COUNTA,AVERAGE),0,0,,MMULT(N(D2:D207={"湖南省","江苏省"}),SEQUENCE(2,,1,0)))

复制代码

无关岁月

1. =GROUPBY(C2:C207,B2:B207,VSTACK(HSTACK(COUNTA,AVERAGE),{"次数","平均分"}),,0,,(D2:D207="江苏省")+(D2:D207="湖南省"))

复制代码

博爱风雨同舟

=LET(s,DROP(GROUPBY(IF($C$2:$C$207=TRANSPOSE(H4:H6),$C$2:$C$207,0/0),$B$2:$B$207,HSTACK(ROWS,AVERAGE),,0,,MMULT(--(D2:D207={"江苏省","湖南省"}),ROW(1:2)^0)),1),IFNA(VSTACK({"周期","次数","平均分"},HSTACK(TOCOL(TAKE(s,,3),3,1),CHOOSECOLS(s,4,5))),""))

sandays

=LET(a,FILTER($B$2:$B$207,(($D$2:$D$207="")+($D$2:$D$207=""))*($C$2:$C$207=$H4)),CHOOSE({1,2},COUNT(a),AVERAGE(a)))