3

#### 3Suk

I have a table below :

Col

Row A B C

1 X 1 2

2 Y 3 4

3 Z 5 6

Then, I have a formula in D1 below, but it only returns "1" as the result, which I expect to be "3" (1+2), please help.

=SUMIF(A:A,"X",B:C)

Thanks,

Patrick.