help with formulas

  • Thread starter Thread starter neka
  • Start date Start date
N

neka

example of what i want to do: take a number from F1 and add it to D2 and then
have the sum placed in F2. i want to set it up to continue to do this for
every new number entered in column D it will then place the new total in
column F. Help!!!!!
 
neka

The first part of your query is simple enough.
In cell F2 enter: =F1+D2

The second part of your query requires a little
more clarification.

George Gee
 
Not too clear on your needs.
i want to set it up to continue to do this for
every new number entered in column D it will then place the new total in
column F
Click to expand...

Where in column F.................F2 or in each progressive cell down column F?

In F2.............=$F$1 + D2 copied down will give you

=$F$1 + D3 in F3

=$F$1 + D4 in F4

Or maybe =$F$1 + SUM(D2:D1000) in F2

Do not copy.


Gord Dibben MS Excel MVP
 
Back
Top