求EXCEL函数高手帮我解决一下~~~谢谢了,小弟我是在不会啊。就是用...答:B6=COUNTIFS(Sheet1!C:C,LEFT(A6),Sheet1!D:D,RIGHT(A6,2))C6=SUMIFS(Sheet1!H:H,Sheet1!C:C,LEFT(A6),Sheet1!D:D,RIGHT(A6,2))D6=AVERAGEIFS(Sheet1!H:H,Sheet1!C:C,LEFT(A6),Sheet1!D:D,RIGHT(A6,2))3、在第三图的空格位置依次输入以下公式,然后向下填充公式 B12=INDEX...