How to make a Running Total formula as a dynamic range

[HeinD]

For auditing purposes I would like to have all my formulas in a dynamic range.
The formulas for running totals I found on this board do work, but I have to drag and copy them over the whole named region it does not automatically recognize it as a dynamic range
I am looking for a formula that will work in a dynamic range and will give me the blue border.
In this picture you see 2 ways for a running total (test2 and test3), they do not autofill or give the blue border, that I do get when I do a (nonsense) calculation like name4.
Anyone a hint?

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	E	F	G	H	I	J	K	L
7	12	34	53	8	37	68	5	35
8	12	46	99	107	144	212	217	252
Data

Cell Formulas
Range	Formula
E8:L8	E8	=SCAN(0,E7:L7,LAMBDA(a,b,a+b))
Dynamic array formulas.

 

[HeinD]

Wow. That solves my problem completely. Thank you.

(for people with the same problem: in my version of Excel I had to adjust it to =SCAN(0,E7:L7,LAMBDA(a;b;a+b)) ; in stead of,)

 

[Fluff]

You're welcome & thanks for the feedback.