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+h...@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

Reply via email to