Hi Bob,

I went to the site and copied the code at the bottom. I went into
toolsmacrosVBA then into InsertModuleand pased the code. Then I used the
following formula:
=SUMPRODUCT(--(ColorIndex(f3:f74,true)=6),f3:f74)
When I hit enter nothing happens. The formula is still just written in the
cell. When I evaluate the formula it just says "the cell currently being
evaluated contains a constant".
I have no idea what I'm doing wrong as this is way beyond my excel skills.
Do you have any thoughts?

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Klee" wrote in message
...
Is there a way to only add cells in a column that have a certain colored
font? I looked at the link at http://www.cpearson.com/excel/colors.htm but
I
couldn't figure out if this can be done or not.

What I need specifically is a way to say: add G100 plus any numbers that
are
blue from G1:G99.

Thanks in advance,
Kris