I need to subtract a range of numbers
 

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?

I need to subtract a range of numbers
 

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?

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?

I need to subtract a range of numbers
 

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?

I need to subtract a range of numbers
 

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 -

I need to subtract a range of numbers
 

Looks like I used a little overkill.<bg
--
Regards,

RD

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