View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
FranksBank
 
Posts: n/a
Default Can Function results be calculated?

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