sumif to add more than one column of cells.

[3Suk]

dear all,
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.

 

[lhkittle]

dear all,

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.

Hi Patrick,

Try:

=SUM(IF(A:A="X",B1+C1,""))

Regards,
Howard

 

[Claus Busch]

Hi Patrick,

Am Sun, 3 Feb 2013 19:12:14 -0800 (PST) schrieb 3Suk:

dear all,
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)

try:
=SUM(IF((A1:A100="X"),B1:C100))
and enter the array formula with CTRL+Shift+Enter


Regards
Claus Busch

 

[lhkittle]

Hi Patrick,



Try:



=SUM(IF(A:A="X",B1+C1,""))



Regards,

Howard

Hi Patrick,
Claus has given you a proper formula. Upon advice I have since gotten, discard mine as it a bit bush-league and use his or maybe this.

=IF(A1="X",B1+C1,0)

Regards,
Howard

 

[3Suk]

Hi Patrick,



Am Sun, 3 Feb 2013 19:12:14 -0800 (PST) schrieb 3Suk:

Claus, Horward,
it works, thanks.
Patrick.