sumif to add more than one column of cells.

  • Thread starter Thread starter 3Suk
  • Start date Start date
3

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.
 
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.
Click to expand...

Hi Patrick,

Try:

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

Regards,
Howard
 
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)
Click to expand...

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


Regards
Claus Busch
 
Hi Patrick,



Try:



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



Regards,

Howard
Click to expand...

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
 
Back
Top