Sum cell and split the value into 2 cells

[harieta]

Impossible or just too complicated for me to write a formula
XX2BL below
I would appreciate your assistance
thank you

I have values in various cells from F2 to Y2 that i need adding together but the sum of it put in 2 cells if certain conditions are met
C2<B2 sum cells F2: Y2 only until they reach the difference between B2 and C2 (in my example 10), if there sum of F2:Y2 is more than that remaining value enter into cell E2
if C2 = B2 sum all cell values and enter the value in E2

formula.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	full	part	top up	rest	var 1	var 2	var 3	var 4	var 5	var 6	var 7	var 8	var 9	var 10	var 11	var 12	var 13	var 14	var 15	var 16	var 17	var 18	var 19	var 20
2	30	20				1			5		2			5		1
3
4
5			if c2<b2 then count cell values f2:y2 with ceiling of difference (b2-c2), remaining value to go to e2
6			if c2=b2, then nothing in d2, all values in e2
7
Sheet1

 

[awoohaw]

you need to select the range of cells in the worksheet before you click "mini sheet".

 

[Fluff]

How about

=IF(C2<B2,MIN(SUM(F2:Y2),B2-C2),"")

and

=LET(s,SUM(F2:Y2),IF(D2="",s,s-D2))