How do I sum color filled cells in Excel with no values or text?

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I only calculate cells which have a filled color format? 1
how do I sum depending on the background color of cells in Excel? 1
How do I sum up values only in cells that are color filled? 7
how do i ignore cells with font color? 3
Query with percetnages.. How do I? 2
how do I sum computed fields in access 3
how do I 'count' the number of cells with a text in red or black? 2
How do I get a letter to represent a number for scheduling? 1

Top