Cumulative SUM & restart count on condition

[CASiddall]

Hi

I have a row in which i input values on a daily basis, and i need these values to be added, until i insert a 'x' in a cell which will reset the sum total, thereafter the cumulative sum will only be after the last cell containing an 'x'.

Assuming i have 365 Columns representing each day in the year, what formula (or macro) can i use in cell 366 that can add values (including blank cells) in a row, but only sum the values after the last cell containing an "x"


Is this possible?
Thanks

 

[FormR]

Hi, welcome to the forum!

Are you looking for something like this?

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L
2	1	5	3	x	1		x	3	x	1	5	6
3	5	5	1	x	x	x	3		5	4	5	17
4	5		1				3	1		4	5	19
5			5			1			2	x	1	1
Sheet1

Cell Formulas
Range	Formula
L2	=SUM(INDEX(A2:K2,IFERROR(LOOKUP(COLUMNS(A2:K2),COLUMN(A2:K2)-MIN(COLUMN(A2:K2))+1/(A2:K2="x")),1)):K2)

 

[CASiddall]

Hi

Yes, this formula is exactly what I want, and it works 100% as intended, thank you very much for your assistance.

Best Regards

 

[Aladin Akyurek]

Slightly different computation, using the post #2 representation...

Control+shift+enter, not just enter, and copy down

=IFERROR(SUM(INDEX(A2:K2,MATCH(9.99999999999999E+307,1/(A2:K2="x"))):K2),0)