Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for totals throughout sheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for totals throughout sheet
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 "Dottled" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for totals throughout sheet
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 "FloMM2" wrote: 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 "Dottled" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for totals throughout sheet
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. "Dottled" wrote in message ... 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 "FloMM2" wrote: 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 "Dottled" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Summary Sheet Totals | Excel Discussion (Misc queries) | |||
Sum totals of 55 worksheets on Sheet 55? | Excel Worksheet Functions | |||
Adding totals to new sheet | Excel Worksheet Functions | |||
Add row above TOTALS to all sheets when done in one sheet. | Excel Worksheet Functions |