Software

Ask something
Discussion Locked

Formula Problems

0 helpful
7 replies

by shantie

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to make a formula that will apply to the whole spreadsheet/workbook.
eg. A B C D E - (E) being the TOTAL column
Daily figures are added to A B C D, and a total is needed in column E, to continue down the page. Okay this is easily done manually but I want excel to auto sum E column as figures are entered in ABCD, all the way down the spreadsheet. I have done this, but does not put the TOTAL going down calculates Grand total and only stays in column E 1, does not bring it down eg E 2, E 3, etc etc. Hope you can understand my explanation and advice, thank you

7 replies

by twobordercollies

The formula in cell E1 should be something like this: =sum(a1:d1)

Then copy the formula down column E. You can use the copy and paste function or you can point to the bottom righthand corner of the E1 and you will see a small cross hairs cursor. When you get that curser hold your left mouse button down and drag it all the way down column E.

by shantie

Pointing to the righthand corner of cell and dragging the small cross did the trick Thank you

This discussion is closed to new replies.