At 15:16 25/03/2013 +0100, Krunoslav ebetiÄ wrote:
I need to make a Calc table. Table is "structured" vertically. Tables sums number values from columns in the last row of table. Every column stands for itself, and has nothing to do with other columns. But values are entered in column by different variables. I have set different cell background color for every variable. Is there a way to tell Calc to sum, divide or multiply values by the cell style color?
Not that I know of. But there is an easier way. I'm guessing that you have set the background colours manually. Instead of doing that, why not create another column to indicate the condition (I'm not sure what you mean by "entered ... by different variables")? You can then use the values in the new column to control the SUMIF() to form your selective sums. But you can also use the values in the new column in "conditional formatting" to set the background colours of the cells in the first place. This is a much more reliable technique.
If you wish, the extra columns can be hidden or displaced to another part of the sheet or even to another sheet, so they do not need to be immediately visible or to print along with the values you do need to see. It may not even be necessary to create new columns, if the conditions they need to contain could be derived directly from whatever is their source.
I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted