Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |