Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hello,

I need to make a Calc table. Table is "structured" verticly. Tables sums number values from collums in the last row of table. Every collum stands for itself, and has nothing do do with oder collums.

But values are enterd in collum by different variables. I have set different cell background color for every variable. Is there a way to tell Calc to sum, devide or multiply values by the cell style color?

I can not enter summed, devidded or multiplied values directly to collum because I need to initials values summed (for each collum) so I want to set some kinde of formula to a different place in sheet with modified values. Maybe it can be done with sumif?

Maybe I am doing it wrong, maybe it can be done different way?

Sory for bad english, I can explain more in depth if necessary.

Kruno

--
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.