I need to subtract a range of numbers

N

natashac

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?
 
B

Bob Phillips

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)
 
N

natashac

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

Pete_UK

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
 
Top