记录几个Excel公式:
COUNTIF(sheet1!A:A,"*"&A1&"*")
COUNTIFS(sheet1!A:A,"*"&A1&"*",sheet1!B:B,"*"&A1&"*")
SUMPRODUCT((Sheet1!A:A="Bug")*(Sheet1!E:E="P2"))
SUMIF(Sheet1!A:A,"*条件*",Sheet1!C:C)
SUMIFS(Sheet1!C:C,Sheet2!A:A,"*条件*",Sheet2!A:A,"*条件*")
记录几个Excel公式:
COUNTIF(sheet1!A:A,"*"&A1&"*")
COUNTIFS(sheet1!A:A,"*"&A1&"*",sheet1!B:B,"*"&A1&"*")
SUMPRODUCT((Sheet1!A:A="Bug")*(Sheet1!E:E="P2"))
SUMIF(Sheet1!A:A,"*条件*",Sheet1!C:C)
SUMIFS(Sheet1!C:C,Sheet2!A:A,"*条件*",Sheet2!A:A,"*条件*")