Alternative Formula vs. Multiple SUMIFs?

[Chazzo]

Hello Everyone,

In Column D in the grid below beginning in row 3, I want to SUM Total the values in row 2 if there's an 'X' or any text value in columns A thru C.

For example in row 3 there is an 'X' in column A which is valued at 20, and an 'X' in column C which is valued at 60 which of course totals to 80.

Currently, I'm using:

=SUMIF(A3,"X",A$2)+SUMIF(B3,"X",B$2)+SUMIF(C3,"X",C$2) which works when copying the formula down HOWEVER...

I would like to avoid SUMIF +SUMIF + SUMIF as the sheet will gain additional columns overtime.

Any suggestions in how I could build a more robust formula to accomplish this?

Thanks in advance.

	A	B	C	D
1	Clip1	Clip2	Clip3	TOTAL
2	20	40	60
3	X		X	80
4	X	X	X	120
5	X			20

<tbody>
</tbody>

 

[jtakw]

Hi,

Put the range in the SUMIF:

Book1
	A	B	C	D
1	Clip1	Clip2	Clip3	TOTAL
2	20	40	60
3	X		X	80
4	X	X	X	120
5	X			20
Sheet137

Cell Formulas
Range	Formula
D3	=SUMIF(A3:C3,"X",A$2:C$2)

Formula copied down.

 

[Chazzo]

Doh..

I knew I was overthinking it.

Thanks jtakw!

 

[jtakw]

You're welcome, "overthinking", that happens to everyone now and then...