How do I sum color filled cells in Excel with no values or text?
I'm creating a shift schedule for 12 employees using an existing template
that has rows of different colors that indicate hours each person is in the office. The company needs a minimum number of employees working during core business hours. I don't want to manually add all the colored cells per half an hour per day to see if there are enough employees. Is there a formula for summing color filled cells? |
How do I sum color filled cells in Excel with no values or text?
See this page Oy
http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Ron de Bruin http://www.rondebruin.nl "Oy!" wrote in message ... I'm creating a shift schedule for 12 employees using an existing template that has rows of different colors that indicate hours each person is in the office. The company needs a minimum number of employees working during core business hours. I don't want to manually add all the colored cells per half an hour per day to see if there are enough employees. Is there a formula for summing color filled cells? |
How do I sum color filled cells in Excel with no values or text?
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Oy!" wrote in message ... I'm creating a shift schedule for 12 employees using an existing template that has rows of different colors that indicate hours each person is in the office. The company needs a minimum number of employees working during core business hours. I don't want to manually add all the colored cells per half an hour per day to see if there are enough employees. Is there a formula for summing color filled cells? |
All times are GMT +1. The time now is 08:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com