當前位置:股票大全官網 - 財經新聞 - Excel表格數據統計咨詢

Excel表格數據統計咨詢

L2單元格輸入公式:

=SUMIFS(D:D,A:A," & lt= " & amp$I$2,B:B,J2,C:C,K2)

L11單元格輸入公式:

=SUMIFS(D:D,A:A," & gt= " & amp$H$11,A:A," & lt= " & amp$I$11,B:B,J11,C:C,K11)

L20單元格輸入公式:

=SUMIFS(D:D,A:A," & gt= " & amp$H$20,A:A," & lt= " & amp$I$20,B:B,J20,C:C,K20)

復制並放下三個公式