condition for line color

[cmar]

I want to create an array formula but need help for a condition that refers
to the cell's color.
My formula would be like this:

{=SUM(IF(condition,VTC,0))}

where VTC is the named range =Consignt!$F:$F

I have colored many lines in the worksheet with a background color of
yellow, blue or pink. I want my "condition" to be that the cell has no
background color, e.g., is white.

How would I express that condition?

Thanks, CMA

 

[Don Guillett]

to count for yellow. For None use 0 instead of 6
=SUMPRODUCT(--(ColorIndex(A1:A21)=6))
to sum b based on a
=SUMPRODUCT(--(ColorIndex(A1:A21)=6),b1:b21)

 

[MartinW]

Just adding to Don's post.

To get ColorIndex to work you will need to get the
code from Bob Phillips's site.
http://xldynamic.com/source/xld.ColourCounter.html

HTH
Martin

 

[Don Guillett]

Oops.