sumproduct多條件求和:sumproduct跨表多條件求和[朗讀]

1.=sumproduct((isnumber(find(＂2012-3-1＂,a1:a3))*(b1:b3=1)*(c1:c3))2.=sumproduct((a1:a3=date(2012,3,1))*(b1:b3={＂兔子百度＂,＂狗狗專＂})*(c1:c3))如果日期是文本屬格式的,公式為:=sumproduct((a1:a3=＂2012-3-1＂)*(b1:b3={＂兔子＂,＂狗狗＂})*(c1:c3))或:=sumproduct((a1:a3=＂2012-3-1＂)*((b1:b3=＂兔子＂)+(b1:b3=＂狗狗＂))*(c1:c3))。