Franco, What do you do to color the cells in the first place? I'm guessing that you use some conditional formatting formula. Just a thought but could you use that same information to derive your sums instead of trying to base it on the colors? Cell formatting is primarily (if not solely) designed for visual effect -- not programmatic control. You might need to add some hidden columns or rows as helpers.
BTW, for future reference, you originally "hijacked" a thread dealing with some malware by using the reply (all?) feature of email and totally changing the subject. This caused the two threads to get intertwined and diluted the impact of your Subject. In this case, "What's done is done." -- Jim -----Original Message----- From: Franco <fra...@w4u.it> To: users@global.libreoffice.org Sent: Sun, 20 Apr 2014 9:24 Subject: [libreoffice-users] Calc Sum cells based on color Hm, html stripped away. Let me retry adding a link to an image explaining what I mean: http://s30.postimg.org/616qwbcb5/calc_sum_colors.png ---------- Hi all, I'm looking for a solution to a problem with Calc similar to many requests I read googling around. Here the question: I have an activity by month table and I want to write in every row the hours employed by some people on that job. I need a way to get a quick look to the entire table so I can visually realize the people/day assignments and redistribute the next activities. There are only few peoples, so I assign a color to everyone and set a background color for the day that person made the job. Example (only 9 days for briefness): Anna: red Marco: green Laura: yellow See the link at the top. Any hint please? Thank you all. Franco -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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