Prev: EXCEL
Next: Why wont my right click functions work?
From: Universal Pegasus - Chad on 10 Feb 2010 12:43
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
From: Bob Phillips on 10 Feb 2010 13:20
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
example

HTH

Bob

"Universal Pegasus - Chad" <UniversalPegasusChad(a)discussions.microsoft.com>
wrote in message news:47783FE2-1237-4736-9AFF-6E5149B8EC03(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: EXCEL
Next: Why wont my right click functions work?