formula for totals throughout sheet

D

Dottled

I would like a forumula so that i can total several columns in a spreadsheet
indefinitely. The rows of data which will change every day and i would like
to be able to add new data to every row and for it to total up every column
indefinitely
 
F

FloMM2

Dottled,
If I understand you correctly, try this:
Column A has dates in it, Column B thru whatever has numbers.
Below, in every column you would like a total,as of the new date that is
entered.

In a new worksheet, put a few rows of data in across your worksheet.

Skip a row, in the next row.
Cell A - Type "Totals"
Cell B - In Cell B5 Type "=SUM(B1:B4)", this is if Cell B4 is empty.
Cell C - Copy Cell B5, across the worksheet to the last column of data.

The next time you eneter data, select the blank row, and "Insert" a row.
Your formula will automatically change.
hth
Dennis
 
D

Dottled

My spreadsheet it like this

10ft 12ft 14ft 14ft ect.......

what i would like to do is anytime a 10ft is used i would add the number
used ie:

10ft 12ft
3 6
4 2
Total Total

etc.................

so every column will change as something is added

Thank you for helping
 
F

Fred Smith

There are two ways to do this: totals at the top, and totals at the bottom.
These instructions assume your data starts in column A, row 1.

For totals at the top:
-- insert a row after your header row (right-click on the number 1 on the
left hand side of the spreadsheet, and choose Insert)
-- In cell a2, enter the formula: =sum(a3:a10000)
-- Copy this formula across your spreadsheet (click on the small black box
on the bottom right of the cell and drag it across)
The advantage of this setup is that new data is easy to add, and
automatically get included in the total.

For totals at the bottom:
-- Click on cell a2. Enter <End><Down> (The End key and the down arrow key).
You should now be at the bottom of column A.
-- Click on the Sigma in the toolbar (The funny looking E). It should create
the Sum formula for you. Hit Enter.
-- Copy the formula across the row.
With this setup, you will need to insert a row every time to want to add
data.

Hope this helps,
Fred.
 
Top