Try this in I3:

=SUMPRODUCT(((B3:G3)-(C3:H3))*(C3:H30))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"natashac" wrote in message
...
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?