A B C
1 week Inventory Change
2 1 12
3 2 15 B3-B2
4 3 4 B4-B3



--

Jakob
"Coopster8" skrev i melding
...
need the answer to stay in the same
cell...(c3-b3)(d3-c3)(e3-d3)(f3-e3)(g3-f3) keeping total in
g3....something
like that, does this make since??? a3 is using a dept # so i don't use it
for
answer

"Coopster8" wrote:

need a formula to add and subtract and give me total..trying to show
inventory level dropping or raising on a weekly bases...something like
this
week 2- week 1, week 3 - week 2, week 4 - week 3, week 5 - week 4 =
total, or
week 1 = 12
week 2 = 15....3
week 3 = 4....(1)
week 4 = 18...17
week 5 = 5....22
total = 22