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




"neka" wrote in message
...
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!!!!!

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(D2:D1000) in F2

Do not copy.


Gord Dibben MS Excel MVP

On Wed, 2 Apr 2008 10:54:00 -0700, neka wrote:

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