[libreoffice-users] Calc Sum cells based on color

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

I need to have as a result the sums based on the background color:

Day
        1
        2
        3
        4
        5
        6
        7
        8
        9
        
        Anna
        Marco
        Laura
Jan
        4
        8
        6
        4
        7
        6
        8
        4
        6
        
        19
        14
        20
Feb
        6
        6
        8
        5
        7
        5
        6
        8
        6
        
        21
        17
        19
Mar
        5
        6
        8
        6
        7
        5
        6
        7
        6
        
        18
        16
        22



Any hint please?
Thank you all.

Franco

--
To unsubscribe e-mail to: users+unsubscribe@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