| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formula to add then subtract
I am trying to add together a group of cells then subtract that total
from another number and put the result into a cell. My formual is: =SUM(B112)-(B106:B111) So what I am trying to do is take the total value of cells B106 through B111 and subtract them from the amount in cell B112. This would then be all in B113. For some reason excel doesn't recoginize the (b106:b111). what am I doing wrong? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel formula to add then subtract
=SUM(B112)-SUM(B106:B111) or =B112-SUM(B106:B111)
Hth, Merjet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel formula to add then subtract
The formula that you have does not match what you stated you are trying to
do. Try this formula (placing it in B113): +B112 - SUM(B106:B111) Les "Dagonini" wrote: I am trying to add together a group of cells then subtract that total from another number and put the result into a cell. My formual is: =SUM(B112)-(B106:B111) So what I am trying to do is take the total value of cells B106 through B111 and subtract them from the amount in cell B112. This would then be all in B113. For some reason excel doesn't recoginize the (b106:b111). what am I doing wrong? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel formula to add then subtract
=SUM(B112)-SUM(B106:B111)
-- Dan |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel formula to add then subtract
=B112-SUM(B106:B11)
Gord Dibben MS Excel MVP On 6 Mar 2007 08:54:55 -0800, "Dagonini" wrote: I am trying to add together a group of cells then subtract that total from another number and put the result into a cell. My formual is: =SUM(B112)-(B106:B111) So what I am trying to do is take the total value of cells B106 through B111 and subtract them from the amount in cell B112. This would then be all in B113. For some reason excel doesn't recoginize the (b106:b111). what am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to subtract percentage from whole | Excel Discussion (Misc queries) | |||
| add & subtract time in 1 formula | Excel Worksheet Functions | |||
| subtract formula | Excel Discussion (Misc queries) | |||
| what excel formula will perform a running subtract from one value | Excel Discussion (Misc queries) | |||
| excel formula that can subtract days | Excel Worksheet Functions | |||
Linear Mode
