What Formula to use for Rolling Inventory?

[exalex]

Hello,

I am looking to create a formula to update a rolling inventory need. please see below - thanks for the help! Need formula for E/F/G BELOW:

	A	B	C	D	e	f	g
1	Current Inventory	Monday sale	Tuesday Sale	Wednesday Sale	Inventory need Monday	Inventory need	Inventory need
2	5		6	1		1	1
3	6	5	3	1		2	1
4	4	9	11	1	5	2	1

<tbody>
</tbody>

 

[jtakw]

Hi,

I'm not understanding your requirement and/or logic here, line 4 in your sample is not adding up for me.
If you can insert a Blank Column after "sale" columns and before "need" columns:

Book1
	A	B	C	D	E	F	G	H
1	Current Inventory	Monday sale	Tuesday Sale	Wednesday Sale		Inventory need Monday	Inventory need Tuesday	Inventory need Wednesday
2	5	0	6	1		0	1	1
3	6	5	3	1		0	2	1
4	4	9	11	1		5	11	1
Sheet45

Cell Formulas
Range	Formula
F2	=MAX(0,SUM($B2:B2)-SUM($A2,$E2:E2))

Formula copied down and across.