Two cells divided into next cell
 

Hope this makes sense. I have F column that totals down to F16. Then I
have a total on D16. I need both totals to be divided and show up on G16.
Every cell has $ Amts, but the only cells not totaled down the row are E,G
and J. So G16 is blank. Is this possible to do and If so how. I don't even
know the formula to Divide and I need this to automatically happen every time
I Insert the Amts in the cells. Please help

In G16:

=D16/F16



"Day" wrote in message
...

Hope this makes sense. I have F column that totals down to F16. Then I
have a total on D16. I need both totals to be divided and show up on G16.
Every cell has $ Amts, but the only cells not totaled down the row are E,G
and J. So G16 is blank. Is this possible to do and If so how. I don't
even
know the formula to Divide and I need this to automatically happen every
time
I Insert the Amts in the cells. Please help

Thank you this did help but I just ran into a problem. When I started
inputting the formula into each cell to calculate what I wanted I noticed
that on my next month column where It's blank, that only that whole column
automatically calculates what I want. I need all colums to automatically do
what the above cells are doing. How do I get the next three columns to do
what the above are doing and what the blank one will do when I input a
number. I inputted fake numbers to see if they will automatically calculate
and that's when I noticed the problem. If you understand please let me know
if you have any ideas.

Thanks, Day

"PCLIVE" wrote:

In G16:

=D16/F16



"Day" wrote in message
...

Hope this makes sense. I have F column that totals down to F16. Then I
have a total on D16. I need both totals to be divided and show up on G16.
Every cell has $ Amts, but the only cells not totaled down the row are E,G
and J. So G16 is blank. Is this possible to do and If so how. I don't
even
know the formula to Divide and I need this to automatically happen every
time
I Insert the Amts in the cells. Please help