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:

[TABLE="width: 714"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]e
[/TD]
[TD]f
[/TD]
[TD]g
[/TD]
[/TR]
[TR]
[TD="align: right"]1
[/TD]
[TD]Current Inventory
[/TD]
[TD]Monday sale
[/TD]
[TD]Tuesday Sale
[/TD]
[TD]Wednesday Sale
[/TD]
[TD]Inventory need Monday
[/TD]
[TD]Inventory need
[/TD]
[TD]Inventory need
[/TD]
[/TR]
[TR]
[TD="align: right"]2
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD="align: right"]4
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]11
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.