How to determine color of a cell?
 

I have a column of numbers that if the cell is a color and another cell is
"Y" then sum the color cells.
Below is my example and below that is an equation I tried, but it did not
work because the ColorIndex(), appears to not traverse through the Array it
only returned the first cell color.
I am a rookie at this, so please excuse the poor example.

Question: Is there a way to get the "Color Index" for each cell in a row and
add the row as I go?
Thanks in advance for any help.

Example:
Row 1: Column A is Y for space charge, Column C is $10 is highlighted RED
Row 2: Column A is Y for space charge, Column C is $20 is not highlighted
Row 3: Column A is N for space charge, Column C is $40 is highlighted RED
Row 4: Column A is N for space charge, Column C is $10 is not highlighted

= SUMIF(and(a1:a4="N",C1:C4=indexcolor(44)),c1:c4,0)

How to determine color of a cell?
 

Check out this link...

http://www.xldynamic.com/source/xld.ColourCounter.html
--
HTH...

Jim Thomlinson


"KW" wrote:

I have a column of numbers that if the cell is a color and another cell is
"Y" then sum the color cells.
Below is my example and below that is an equation I tried, but it did not
work because the ColorIndex(), appears to not traverse through the Array it
only returned the first cell color.
I am a rookie at this, so please excuse the poor example.

Question: Is there a way to get the "Color Index" for each cell in a row and
add the row as I go?
Thanks in advance for any help.

Example:
Row 1: Column A is Y for space charge, Column C is $10 is highlighted RED
Row 2: Column A is Y for space charge, Column C is $20 is not highlighted
Row 3: Column A is N for space charge, Column C is $40 is highlighted RED
Row 4: Column A is N for space charge, Column C is $10 is not highlighted

= SUMIF(and(a1:a4="N",C1:C4=indexcolor(44)),c1:c4,0)

How to determine color of a cell?
 

Jim,

Thanks for the information, took me a bit to figure out how to use the
information, but once I did it hit the spot. THANKS

"Jim Thomlinson" wrote:

Check out this link...

http://www.xldynamic.com/source/xld.ColourCounter.html
--
HTH...

Jim Thomlinson


"KW" wrote:

I have a column of numbers that if the cell is a color and another cell is
"Y" then sum the color cells.
Below is my example and below that is an equation I tried, but it did not
work because the ColorIndex(), appears to not traverse through the Array it
only returned the first cell color.
I am a rookie at this, so please excuse the poor example.

Question: Is there a way to get the "Color Index" for each cell in a row and
add the row as I go?
Thanks in advance for any help.

Example:
Row 1: Column A is Y for space charge, Column C is $10 is highlighted RED
Row 2: Column A is Y for space charge, Column C is $20 is not highlighted
Row 3: Column A is N for space charge, Column C is $40 is highlighted RED
Row 4: Column A is N for space charge, Column C is $10 is not highlighted

= SUMIF(and(a1:a4="N",C1:C4=indexcolor(44)),c1:c4,0)