How to write this a excel formula?

[MrNewExcel]

 

[JamesCanale]

MrExcelPlayground8.xlsx
	A	B	C	D	E	F
1	X		1	2	3	4
2		X	1	2	3	5
3	X	X	1	2	3	6
4			1	2	3	3
Sheet5

Cell Formulas
Range	Formula
F1:F4	F1	=SUMPRODUCT(C1:E1,--(A1:C1<>""))

 

[MrNewExcel]

Nko

MrExcelPlayground8.xlsx
	A	B	C	D	E	F
1	X		1	2	3	4
2		X	1	2	3	5
3	X	X	1	2	3	6
4			1	2	3	3
Sheet5

Cell Formulas
Range	Formula
F1:F4	F1	=SUMPRODUCT(C1:E1,--(A1:C1<>""))

Ohh my God. Solve instantly. Great help. Thank very much for the help.