| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the formula for subtracting the sum total of two cells
What is the formula for subtracting the sum total of two cells in nonadjacent
(nonconnecting) cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the formula for subtracting the sum total of two cells
A1 = 120
D1 = 200 F1 has formula =D1-A1 returning 80 Other than that, don't know what you need. Gord Dibben MS Excel MVP On Tue, 28 Nov 2006 14:27:01 -0800, Sundew Chocobo <Sundew wrote: What is the formula for subtracting the sum total of two cells in nonadjacent (nonconnecting) cells? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the formula for subtracting the sum total of two cells
For example D30 is =sum(d2:d28) f30 is =sum(e12/10) G30 is =sum(G2:G28)
now what I want is d35 = D30-G30 F35 =D35 + F30 Does this explain the problem better "Sundew Chocobo" wrote: What is the formula for subtracting the sum total of two cells in nonadjacent (nonconnecting) cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| How do I search for a total using nonadjacent cells | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
