Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Totals: Group totals different from Grand totals PsyberFox Excel Discussion (Misc queries) 1 February 13th 08 07:16 PM
Summary Sheet Totals Bowtie63 Excel Discussion (Misc queries) 7 October 29th 07 08:54 PM
Sum totals of 55 worksheets on Sheet 55? L. S. Martin Excel Worksheet Functions 3 August 27th 07 07:50 PM
Adding totals to new sheet Doug[_3_] Excel Worksheet Functions 9 August 1st 07 03:51 AM
Add row above TOTALS to all sheets when done in one sheet. Invoice Excel Worksheet Functions 0 August 31st 06 05:55 AM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"