Is this some kind of weight loss program, so you want to subtract the
latest value from the first as the weeks progress? Try this in I3:

=B3-LOOKUP(999,B3:H3)

Hope this helps.

Pete

On Oct 2, 12:13 am, natashac
wrote:
I tried that but it gives me the nubmer in B3. I need to see a running total.

Her is what I have so far

B3 C3 D3 E3 F3 G3 H3 I3
129 127 ? ? ? ? ? total loss

I need to add a new number each week to show the loss as it progresses.
Once I get to H3 it would be my total loss but I have to keep track of each
weeks loss.



"Bob Phillips" wrote:
Do you mean

=B3-H3

Probably not, so maybe more detail.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"natashac" wrote in message
...
I want to show how much is lost in a row from B3:H3. I have two figures
already 129 and 127 however there will be other figures added later. What
formula do I need to use to show the amount lost after H3?- Hide quoted text -

- Show quoted text -