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

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