Bob, It don't work. My excel is in Portuguese, I try to use sumproduct
(somarproduto) with out any result. I'm too green on this functions or VBA
matters.
Thanks any way

Nuno Jácome


"Bob Phillips" escreveu:

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Nuno Jácome" wrote in message
...
How could I sum only the red values from A1:A10
I heard about sumcolor fucntion, but I could find it on my excel.

Any help