View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TKinHawaii
 
Posts: n/a
Default Simple, but not for me...help

Tried that and the formula did not carry down, the next colum in the
Total remainded blank.

TK

"Duke Carey" wrote:

OK, it appears you haven't used Excel very much at all.

After you've entered the 2d formula, keep that cell active. Notice at the
bottom right corner of the cell border there is a little square? And when
the mouse hovers over that square it turns into a + symbol, too. Notice
that? Now double click that little square and your formula will be copied
down for you.



"TKinHawaii" wrote:

I will have hundreds or rows, I have to copy this formula into each one ?
If that is the case it would be just as easy to use the calculator, add and
insert the number. If the program will not do a simple, ongoing, function
like this.......I am surprised.

Thanks,

TK

"Duke Carey" wrote:

In the very first row (let's assume it's row 2), use this formula in E2

=D2

in E3 use

=E2+D3

and copy it down as needed


"TKinHawaii" wrote:

Trying to set up a simple spreadsheet. Columns A, B, C are client information
Column D is Invoice (current one in dollars) Column E is to be total to date,
for all the invoices in Column D,
adding column D to E each time for a running total. I cannot get this to work.
Is there not a simple way to do this basic function ?

Thanks,

TK