formula help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
B1: = A1
B2: = A2-B1

copy B2 down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
 
Use this:

G3:=SUM($A$3:G3)

If I understand correct: in A3 is the absolute amount on week 0. In
the other Columns are the differences made during every week. On the
right of the row you want the absolute amount calculated.

After one week passed you want to insert a Column and type in the
difference made that particular week. You want the calculation to
adjust to the changes you made by inserting a new column.

Success,

Bart
 
Bart, you came the close to understanding what i was trying to say, but when
i type that formula in cell (g) it shows the formula
sent you and email, hoping it will show you what i want done, i may not be
explaining myself clear
 
In cell G3 you type:

=sum($B3:F3)

With the '$' sign in the formula you prevent Excel changing the
formula on that part of the formula when copying it to other cells or
inserting columns. You could read the help files about this: search
for 'Reference' and find the help item 'Switch between relative,
absolute, and mixed references' (English version). Also you could
experiment with it to get a better understanding of these functions.

Good luck,

Bart
 
Back
Top