SUMCOLOR

N

Nuno Jácome

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
 
P

Paul B

Nuno, have a look here for a way to do it,

http://www.cpearson.com/excel/colors.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
N

Nuno Jácome

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

Nuno Jácome

"Paul B" escreveu:
 
N

Nuno Jácome

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:
 
B

Bob Phillips

Don't forget to use semi-colons instead of commas as well.

--

HTH

Bob Phillips

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