谁能帮我解释解释这两个excel公式的实际意义,
=SUMPRODUCT(SUMIF(INDIRECT(ROW($1:$12)&"月!F:F"),B6,INDIRECT(ROW($1:$12)&"月!R:R")))=SU...
=SUMPRODUCT(SUMIF(INDIRECT(ROW($1:$12)&"月!F:F"),B6,INDIRECT(ROW($1:$12)&"月!R:R")))
=SUMPRODUCT(COUNTIF(INDIRECT(ROW($1:$12)&"月!F:F"),B6)) 展开
=SUMPRODUCT(COUNTIF(INDIRECT(ROW($1:$12)&"月!F:F"),B6)) 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询