View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FloMM2 FloMM2 is offline
external usenet poster
 
Posts: 207
Default 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