Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|