Formula needed

[Overtor105]

I need a formula to sum total cells after the last "0" entered within a row. In the attached example, the "?" should read "4".

Thank you in advance!

 

[Cubist]

I'm assuming you have XMATCH.

Book1
	B	C	D	E	F	G	H	I	J	K
1	1	0	1	1	0	1	1	1	1	4
Sheet1

Cell Formulas
Range	Formula
K1	K1	=COUNTA(B1:J1)-XMATCH(0,B1:J1,,-1)

 

[Overtor105]

I'm assuming you have XMATCH.

Book1
	B	C	D	E	F	G	H	I	J	K
1	1	0	1	1	0	1	1	1	1	4
Sheet1

Cell Formulas
Range	Formula
K1	K1	=COUNTA(B1:J1)-XMATCH(0,B1:J1,,-1)

Exactly what I'm looking for....THANK YOU!!

 

[bobsan42]

The COUNT is ok if the numbers are 1s.
I believe that since the question was about SUM this will be a more correct approach:

=SUM(TAKE(B1:K1,1,-(COLUMNS(B1:K1)-XMATCH(0,B1:K1,,-1))))

 

[Fluff]

Another option is you can numbers other than 0 and 1

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1
2		1	1	1	1	1	0	1	2	1	4
Data

Cell Formulas
Range	Formula
K2	K2	=SUM(XLOOKUP(0,B2:J2,B2:J2,B2,,-1):J2)