spreadsheet sum formula

  • Thread starter Thread starter billy bob
  • Start date Start date
B

billy bob

Excel 2003, part of Office Small Business

I have created a spreadsheet with multiple columns. Some
of the columns have text; some have dates; some have
currency amounts.
For example: column A - text
column B - date
column C - currency amount [ US Dollars ]

1. I want to have the currency amounts automatically sum
[ cause a total to be created ], after each entry. Items
will be added to each column on a periodic basis, sometimes
daily, most certainly weekly.

2. I would like to "export" the totals from the currency
columns to a different page, for year end tax purposes.
This could be a different spreadsheet, or a new page within
the same spreadsheet.

Thanks for your help.

BB
 
Hi!

To obtain a total for the currency amounts in column C:

=SUM(C5:C100)

This will automatcally update as you enter data within the
range of cells from C5 to C100 AS LONG AS you have
calculation set to AUTOMATIC. Check
Tools>Options>Calculation>Automatic.

To "export" the total to another sheet simply link to the
cell that the SUM formula is in. eg:

Sheet1 cell C110 holds the formula =SUM(C5:C100).

In Sheet5 cell A1 enter =Sheet1!C110

Biff
 
Biff:
Sounds easy enough.

Thanks.

BB
-----Original Message-----
Hi!

To obtain a total for the currency amounts in column C:

=SUM(C5:C100)

This will automatcally update as you enter data within the
range of cells from C5 to C100 AS LONG AS you have
calculation set to AUTOMATIC. Check
Tools>Options>Calculation>Automatic.

To "export" the total to another sheet simply link to the
cell that the SUM formula is in. eg:

Sheet1 cell C110 holds the formula =SUM(C5:C100).

In Sheet5 cell A1 enter =Sheet1!C110

Biff
-----Original Message-----
Excel 2003, part of Office Small Business

I have created a spreadsheet with multiple columns. Some
of the columns have text; some have dates; some have
currency amounts.
For example: column A - text
column B - date
column C - currency amount [ US Dollars ]

1. I want to have the currency amounts automatically sum
[ cause a total to be created ], after each entry. Items
will be added to each column on a periodic basis, sometimes
daily, most certainly weekly.

2. I would like to "export" the totals from the currency
columns to a different page, for year end tax purposes.
This could be a different spreadsheet, or a new page within
the same spreadsheet.

Thanks for your help.

BB


.
Click to expand...
.
Click to expand...
 
Back
Top