请问有无EXCEL 高手?

我想系 红色格仔(J2) 入一个SUMIFS FORMULA(含OR):
SUM RANGE = 将B:B 加埋一齐
条件:
1) A:A = Apple
2) c:c = A1 同 A2

我条FORMULA系:
=SUMIFS(B:B,A:A,"Apple",C:C,OR("A1","A2"))
但结果系出 0
请问系咩问题?

Excel evaluates the criteria in SUMIFS formula like this:If (A:A = "Apple" ) AND (C:C = OR("A1", "A2" )) and the OR("A1", "A2") returns #VALUE, so 0 is returned for your formula.You can verify it by input a new record with "Apple" as item, 123 as amount and #VALUE! as location. The formula should be returning 123 now.Please change your formula to =SUM(SUMIFS($B:$B,$A:$A,"Apple",$C:$C,{"A1","A2"}))

[[i] 本帖最后由 wi11s 於 2014-5-18 06:20 PM 编辑 [/i]]