Never mind. I found what I was looking for by saving a defined range. It
also looks like that if you have a defined range saved, the autofilter
automatically picks that up.
I love this program!
Chuck
Chuck wrote:
> 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]
