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.
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 li
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 on
Niklas Nebel wrote:
> Chuck wrote:
>
>> 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 li
Chuck wrote:
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 throu