Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi all
I have a sheet with two columns of figures. I show the running totals of each column in cells with basic SUM Functions, at the top of the sheet. I now want to subtract one total from the other. How is this done? As the Function is looking at cells that themselves hold Functions, I can't see how to do this, short of making a longer Function that adds the column contents again and then subtracts. So, in summary: I have two cells with Functions. These a Cell F4 =SUM(F8:F45) and Cell G4 =SUM(G8:G45) I want to do this: =F4-G4 but it won't play. Any advice most appreciated. Kind regards Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Omit blank cells from function results | Excel Worksheet Functions | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Using function results as parameters in another function | Excel Worksheet Functions | |||
Function Formula is displayed not results | Excel Worksheet Functions |