=sumproduct(sheet1!c2:c1000="重庆")(sheet1!k2:K2:k1000="已买"）(sheet1!h2:h1000=重庆!a3)) a3日期

分类: 作业答案 • 2022-07-24 15:40:51

问题描述：

=sumproduct(sheet1!c2:c1000="重庆")*(sheet1!k2:K2:k1000="已买"）*(sheet1!h2:h1000=重庆!a3)) a3日期

答

你的公式先求符合3个条件的行数吧?
如果是,列式错误,应改为：
=SUMPRODUCT((Sheet1!C2:C1000="重庆")*(Sheet1!K2:K1000="已买")*(Sheet1!H2:H1000=重庆!A3))

=sumproduct(sheet1!c2:c1000="重庆")*(sheet1!k2:K2:k1000="已买"）*(sheet1!h2:h1000=重庆!a3)) a3日期