| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract numbers | Excel Discussion (Misc queries) | |||
| Increment and subtract Numbers | Excel Worksheet Functions | |||
| Subtract Range Of Numbers using a Formula | Excel Discussion (Misc queries) | |||
| subtract 3 numbers and 2 cells | New Users to Excel | |||
| How to subtract two numbers in excel ? | Excel Worksheet Functions | |||
Linear Mode
