SUMIFS across multiple columns and one row

[ryxk1]

How can I find the sum of the values in columns 1-3 if column A equals Yes, column B equals FC, column C equals LE? This is just a sample set, the dataset I'm using has many more columns. Thanks.

[TABLE="width: 640"]
<colgroup><col width="64" style="width:48pt" span="10"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]A[/TD]
[TD="width: 64, bgcolor: transparent"]B[/TD]
[TD="width: 64, bgcolor: transparent"]C[/TD]
[TD="width: 64, bgcolor: transparent"]D[/TD]
[TD="width: 64, bgcolor: transparent"]E[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]1[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]2[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]3[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]4[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]FC[/TD]
[TD="bgcolor: transparent"]LE[/TD]
[TD="bgcolor: transparent"]TB[/TD]
[TD="bgcolor: transparent"]PM[/TD]
[TD="bgcolor: transparent, align: right"]0.5[/TD]
[TD="bgcolor: transparent, align: right"]0.5[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[TD="bgcolor: transparent, align: right"]0.005[/TD]
[TD="bgcolor: transparent, align: right"]0.005[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]TC[/TD]
[TD="bgcolor: transparent"]RF[/TD]
[TD="bgcolor: transparent"]TV[/TD]
[TD="bgcolor: transparent"]PM[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[TD="bgcolor: transparent, align: right"]0.005[/TD]
[TD="bgcolor: transparent, align: right"]0.005[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"]VC[/TD]
[TD="bgcolor: transparent"]LE[/TD]
[TD="bgcolor: transparent"]TC[/TD]
[TD="bgcolor: transparent"]PM[/TD]
[TD="bgcolor: transparent, align: right"]0.6[/TD]
[TD="bgcolor: transparent, align: right"]0.6[/TD]
[TD="bgcolor: transparent, align: right"]0.7[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]No[/TD]
[TD="bgcolor: transparent"]FC[/TD]
[TD="bgcolor: transparent"]LE[/TD]
[TD="bgcolor: transparent"]TC[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent, align: right"]0.7[/TD]
[TD="bgcolor: transparent, align: right"]0.7[/TD]
[TD="bgcolor: transparent, align: right"]0.7[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]FC[/TD]
[TD="bgcolor: transparent"]LE[/TD]
[TD="bgcolor: transparent"]TB[/TD]
[TD="bgcolor: transparent"]PM[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0.7[/TD]
[TD="bgcolor: transparent, align: right"]0.8[/TD]
[TD="bgcolor: transparent, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Yes[/TD]
[TD="bgcolor: transparent"]TC[/TD]
[TD="bgcolor: transparent"]RF[/TD]
[TD="bgcolor: transparent"]TB[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0.7[/TD]
[TD="bgcolor: transparent, align: right"]0.9[/TD]
[TD="bgcolor: transparent, align: right"]0.9[/TD]
[/TR]
</tbody>[/TABLE]

 

[arthurbr]

Perhaps

=sumproduct((a2:a7="yes")*(b2:b7="FC")*(c2:c7="LE")*(f2:j7))

 

[jtakw]

Hi,

If it's the "Total" of column 1-3, the last 2 columns probably shouldn't be included in the formula.
You thread title said "one row", formula included:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Yes	FC	LE	TB	PM	0.5	0.5	0.8	0.005	0.005		1.8	2.5
3	Yes	TC	RF	TV	PM	0.8	0.8	0.8	0.005	0.005
4	No	VC	LE	TC	PM	0.6	0.6	0.7	0.8	0.8
5	No	FC	LE	TC	N/A	0.7	0.7	0.7	0.8	0.8
6	Yes	FC	LE	TB	PM	0	0	0.7	0.8	0.9		0.7
7	Yes	TC	RF	TB	N/A	0	0	0.7	0.9	0.9
Sheet172

Cell Formulas
Range	Formula
L2	=IF(AND(A2="Yes",B2="FC",C2="LE"),SUM(F2:H2),"")
M2	=SUMPRODUCT((A2:A7="Yes")*(B2:B7="FC")*(C2:C7="LE")*(F2:H7))

L2 formula copied down.