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.

A	B	C	D	E	1	2	3	4	5
Yes	FC	LE	TB	PM	0.5	0.5	0.8	0.005	0.005
Yes	TC	RF	TV	PM	0.8	0.8	0.8	0.005	0.005
No	VC	LE	TC	PM	0.6	0.6	0.7	0.8	0.8
No	FC	LE	TC	N/A	0.7	0.7	0.7	0.8	0.8
Yes	FC	LE	TB	PM	0	0	0.7	0.8	0.9
Yes	TC	RF	TB	N/A	0	0	0.7	0.9	0.9

<colgroup><col width="64" style="width:48pt" span="10"> </colgroup><tbody>
</tbody>

 

[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.