SUMIF - SUM FROM TWO COLUMNS

[amit96]

Hello,

someone knows how can i sum two coulmns in sumif?

explenation -

if range B3:B1700 = B3 ,then sum
coulmns "W" and "X"
(im in cell Y3)



thank you!

 

[jtakw]

Hi,

May be:

=SUMIF(B3:B1700,B3,W3:W1700)+SUMIF(B3:B1700,B3,X3:X1700)

 

[etaf]

does
=SUMPRODUCT(($W$3:$X$1700)*($B$3:$B$1700=$B$3))
work

Sumproduct grid based on Header.xlsx
	A	B	C																		U	V	W	X	Y
1
2
3		a																					1	7	22
4		b																					2	8
5		c																					3	1
6		a																					4	2
7		a																					5	3
8		c																					6	4
Sheet2

Cell Formulas
Range	Formula
Y3	Y3	=SUMPRODUCT(($W$3:$X$1700)*($B$3:$B$1700=$B$3))