I believe he needs both conditional formatting and conditional summation...
http://www.openofficetips.com/blog/archives/2005/03/conditional_for.html http://www.openofficetips.com/blog/archives/2004/12/basic_functions_7.html On 11/26/05, CPHennessy <[EMAIL PROTECTED]> wrote: > On Mon November 7 2005 19:17, John Stile wrote: > > calc question - Is it possible to create an equation that totals all > > cells with a particular colored background? > > > > Problem: I have a spread sheet full of different of bills, one column > > of descriptions and one of amounts. I would like to set the background > > of related item amounts, and use an equation to calculate the sum total. > > If I go back and change the background of another cell, or remove the > > color from one, I don't want to have to recalculate the sum total. > > Maybe you could use conditional formatting ? > > -- > CPH : openoffice.org contributor > > Maybe your question has been answered already? > http://user-faq.openoffice.org/#FAQ > > --------------------------------------------------------------------- > 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]
