help with formulas

[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!!!!!

 

[George Gee]

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

 

[Gord Dibben]

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

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(D21000) in F2

Do not copy.


Gord Dibben MS Excel MVP