I need to subtract a range of numbers

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

Guest

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?
 
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)
 
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.
 
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
 
Back
Top