SUMCOLOR
 

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

SUMCOLOR
 

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

"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

SUMCOLOR
 

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

SUMCOLOR
 

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:

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

"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

SUMCOLOR
 

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

SUMCOLOR
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Nuno Jácome" wrote in message
...
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