SUM formula (sort of)
 

Hey guys hopefully someone can help me out on this issue. I've not messed
with formulas in excel in over 5 years so i'm a tad rusty.

Heres what im trying to do.
We're doing a "biggest loser" type of contest at work and what we're trying
to do is setup a formula that will take the starting weight (we'll call that
cell a2) minus the ending weight (we'll call that h2) and do the difference
in the 2 cells. That part is easy but what i'm trying to figure out is how i
can actually keep it like a running count. If theres no value in h2 (which
is going to be our last week) i'd like for it to step back and pull the
weight from the previous week (cell g2) and subtract that from cell a2 and if
no value in g2 move back to f2 etc... Hopefully this isnt
confusing..Basically week to week i want to it subtract from cell a2 so we
can see our progress. I can always just tweak the formula from week to week
and change the cell in the formula but would rather just type in the weigh-in
values and let it just calculate the difference.
can anyone help?

SUM formula (sort of)
 

Try this:

=A2-LOOKUP(5000,A2:H2)

--
Biff
Microsoft Excel MVP


"cjones4mvp" wrote in message
...
Hey guys hopefully someone can help me out on this issue. I've not messed
with formulas in excel in over 5 years so i'm a tad rusty.

Heres what im trying to do.
We're doing a "biggest loser" type of contest at work and what we're
trying
to do is setup a formula that will take the starting weight (we'll call
that
cell a2) minus the ending weight (we'll call that h2) and do the
difference
in the 2 cells. That part is easy but what i'm trying to figure out is
how i
can actually keep it like a running count. If theres no value in h2
(which
is going to be our last week) i'd like for it to step back and pull the
weight from the previous week (cell g2) and subtract that from cell a2 and
if
no value in g2 move back to f2 etc... Hopefully this isnt
confusing..Basically week to week i want to it subtract from cell a2 so we
can see our progress. I can always just tweak the formula from week to
week
and change the cell in the formula but would rather just type in the
weigh-in
values and let it just calculate the difference.
can anyone help?