Perhaps a look in the help index for SUBTOTAL would be helpful.
Don Guillett
SalesAid Software
[EMAIL PROTECTED]
----- Original Message -----
From: "bobwarasila" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, September 16, 2006 7:49 AM
Subject: Removing hidden data from a column sum
I've created a spreadsheet to track hours and budget items for
architectural projects. The various projects are organized as rows and
updated each month. The projects last from a few months to over a year
and when a project is finished I hide it's rows but I would like to keep
it in the spreadsheet for at least a year. However I would like the data
to no longer be included in the column sums. Is there a simple way to
keep hidden data from contributing to the sums when I hide it?
Bob Warasila
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
----------------------------------------
To Change your email Address for this list, send the following message:
CHANGE WIN-HOME your_old_address your_new_address
to: [EMAIL PROTECTED]
Note carefully that both old and new addresses are required.
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date: 9/15/2006
--
----------------------------------------
To Change your email Address for this list, send the following message:
CHANGE WIN-HOME your_old_address your_new_address
to: [EMAIL PROTECTED]
Note carefully that both old and new addresses are required.
