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]
