If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell Color Recognition and Summing of Data Within a Specified Colo
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 |
#2
|
|||
|
|||
Cell Color Recognition and Summing of Data Within a Specified Colo
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
example HTH Bob "Universal Pegasus - Chad" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|