recognition of coloured squares

P

princecharlie

what is the formulae for excel to recognise coloured squares and add up the
content?
 
P

princecharlie

Many thanks forthe link but it seems to dpend on = ColorIndex numbers which i
cannot find despite using the formulae .I het #NAME?or #REF?
Any suggestions?
Thsnks for your interest
 
B

Bob Phillips

You can also use it to pick up the colorindex number from a cell, like

=SUMPRODUCT(--(Colorindex(A1:A100)=Colorindex(A1))

This will find all instances of the colour in A1 in A1:A100.

Or you could colour a cell, say H1, and use H1 in the above formula.

You can also get the ColorIndex numbers by looking up ColorIndex Property in
VBA help.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top