That was exactly what I was looking for. Thanks.
Now I have just one more question. My column headers are not on row 1.
They are on row 2. This is because I wanted to have a sum/subtotal cell
*above* one of the columns. It makes sense to me because that way I can
have the total above the freeze line so that when I'm scrolling through
a spreadsheet I can always see the total for that column. Plus I never
have to move the total cell as I add additional rows. Is there a way to
permanently tell Calc that line 2 will always contain the headers for
filtering purposes? Or do I have to reselect the range, starting at row
2, every time I want to apply a filter?
TIA again.
Chuck
David Chapman wrote:
> Use the SUBTOTAL function. See attached...
>
> http://www.openofficetips.com/blog/archives/2005/03/basic_functions_9.html
>
> On 12/1/05, Chuck <[EMAIL PROTECTED]> wrote:
>
>>Can this be done? I want a cell to be the sum() of a column. If there's
>>an active filter I only want the sum of the visible rows. If there's no
>>active filter I want it to be the sum of all rows.
>>
>>TIA
>>
>>Chuck
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
>
>
> --
> My OpenOffice Calc Website
> http://www.openofficetips.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
