View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
natashac natashac is offline
external usenet poster
 
Posts: 2
Default I need to subtract a range of numbers

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?