在C2输入公式=INDEX(A:A,MIN(IF(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2:$100),60000)))&""数组公式,公式在编辑状态按shift+ctrl+ENTER结束,在D2输入公式=IF(C2="","",SUMIF(A:A,C2,B$1)),选中C2和D2向下填充公式.
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/04 22:34:30
![在C2输入公式=INDEX(A:A,MIN(IF(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2:$100),60000)))&](/uploads/image/z/2650781-29-1.jpg?t=%E5%9C%A8C2%E8%BE%93%E5%85%A5%E5%85%AC%E5%BC%8F%3DINDEX%28A%3AA%2CMIN%28IF%28COUNTIF%28C%241%3AC1%2CA%242%3AA%24100%29%3D0%2CROW%28%242%3A%24100%29%2C60000%29%29%29%26%22%22%E6%95%B0%E7%BB%84%E5%85%AC%E5%BC%8F%2C%E5%85%AC%E5%BC%8F%E5%9C%A8%E7%BC%96%E8%BE%91%E7%8A%B6%E6%80%81%E6%8C%89shift%2Bctrl%2BENTER%E7%BB%93%E6%9D%9F%2C%E5%9C%A8D2%E8%BE%93%E5%85%A5%E5%85%AC%E5%BC%8F%3DIF%28C2%3D%22%22%2C%22%22%2CSUMIF%28A%3AA%2CC2%2CB%241%29%29%2C%E9%80%89%E4%B8%ADC2%E5%92%8CD2%E5%90%91%E4%B8%8B%E5%A1%AB%E5%85%85%E5%85%AC%E5%BC%8F.)
在C2输入公式=INDEX(A:A,MIN(IF(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2:$100),60000)))&""数组公式,公式在编辑状态按shift+ctrl+ENTER结束,在D2输入公式=IF(C2="","",SUMIF(A:A,C2,B$1)),选中C2和D2向下填充公式.
在C2输入公式=INDEX(A:A,MIN(IF(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2:$100),60000)))&""数组公式,公式在编辑状态按shift+ctrl+ENTER结束,在D2输入公式=IF(C2="","",SUMIF(A:A,C2,B$1)),选中C2和D2向下填充公式.
在C2输入公式=INDEX(A:A,MIN(IF(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2:$100),60000)))&""数组公式,公式在编辑状态按shift+ctrl+ENTER结束,在D2输入公式=IF(C2="","",SUMIF(A:A,C2,B$1)),选中C2和D2向下填充公式.
(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2:$100),60000)))&""(C2="","",SUMIF(A:A,C2,B$1)),这个俩个公式剩一下就好了