help with formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

neka - 02 Apr 2008 18:54 GMT

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

Reply to this Message

George Gee - 02 Apr 2008 20:16 GMT

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

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

Reply to this Message

Gord Dibben - 02 Apr 2008 23:41 GMT

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

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

Reply to this Message