Reply to thread

Message: [QUOTE="Universal Pegasus - Chad, post: 3857067"] I've tried SUMIFS to recognize cell colors and add the numbers (which are hours worked in the day) in the corresponding row. The kicker is the yellow cell doesn't necessarily have the same hours and I can't get Excel to recognize colors only for one of my criteria. It could range from 2 to 12 hours for any given day. The row may contain data with up to five different colors associated depending on the kind of work performed that day. So let's say I want to pull all yellow cells for a given time period and it looks something like the following. A B C D E F Yellow Cell Blue Cell Yellow Cell Red Cell Black Cell 1 1/1 1/2 1/3 1/4 1/5 2 4-Man Crew 10 10 8 8 6 Indications below column headers in example above are not in spreadsheet. Could not color B2 Yellow, C2 Blue, D2 Yellow for these purposes. Thanks [/QUOTE]