Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range.
I need to get tthe sum of cells with certain colors in a range.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range.
Sum or count coloured cells
If it is manually coloured, see http://www.xldynamic.com/source/xld.ColourCounter.html if it is conditionally formatted, see http://www.xldynamic.com/source/xld.CFConditions.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chuckc" wrote in message ... I need to get tthe sum of cells with certain colors in a range. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range
Bernard,
i think the xldynamic site has be hacked. both sites you posted take me to this site. http://www.123-reg.co.uk/ i check my library and all xldynamic entries take me to the above site. all other sites in my library(or at least those tested) take me to the correct and expected site. so i am posting chip persons equivilant just in case the OP has problems too. http://www.cpearson.com/excel/CFColors.htm http://www.cpearson.com/Excel/colors.aspx and please, someone else test the xldynamic site to make sure that i haven't been hacked. Regards FSt1 "Bernard Liengme" wrote: Sum or count coloured cells If it is manually coloured, see http://www.xldynamic.com/source/xld.ColourCounter.html if it is conditionally formatted, see http://www.xldynamic.com/source/xld.CFConditions.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chuckc" wrote in message ... I need to get tthe sum of cells with certain colors in a range. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range
I got the same result. Domain registry.
"FSt1" wrote in message ... Bernard, i think the xldynamic site has be hacked. both sites you posted take me to this site. http://www.123-reg.co.uk/ i check my library and all xldynamic entries take me to the above site. all other sites in my library(or at least those tested) take me to the correct and expected site. so i am posting chip persons equivilant just in case the OP has problems too. http://www.cpearson.com/excel/CFColors.htm http://www.cpearson.com/Excel/colors.aspx and please, someone else test the xldynamic site to make sure that i haven't been hacked. Regards FSt1 "Bernard Liengme" wrote: Sum or count coloured cells If it is manually coloured, see http://www.xldynamic.com/source/xld.ColourCounter.html if it is conditionally formatted, see http://www.xldynamic.com/source/xld.CFConditions.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chuckc" wrote in message ... I need to get tthe sum of cells with certain colors in a range. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range.
I have extensive documentation and code examples for working with colors, including summing by color(s) at http://www.cpearson.com/Excel/colors.aspx Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 24 Jul 2009 15:37:17 -0700, chuckc wrote: I need to get tthe sum of cells with certain colors in a range. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range
thank you. it's not just me.
"JLGWhiz" wrote: I got the same result. Domain registry. "FSt1" wrote in message ... Bernard, i think the xldynamic site has be hacked. both sites you posted take me to this site. http://www.123-reg.co.uk/ i check my library and all xldynamic entries take me to the above site. all other sites in my library(or at least those tested) take me to the correct and expected site. so i am posting chip persons equivilant just in case the OP has problems too. http://www.cpearson.com/excel/CFColors.htm http://www.cpearson.com/Excel/colors.aspx and please, someone else test the xldynamic site to make sure that i haven't been hacked. Regards FSt1 "Bernard Liengme" wrote: Sum or count coloured cells If it is manually coloured, see http://www.xldynamic.com/source/xld.ColourCounter.html if it is conditionally formatted, see http://www.xldynamic.com/source/xld.CFConditions.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chuckc" wrote in message ... I need to get tthe sum of cells with certain colors in a range. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range
Bob's been having problems for a while.
Last I heard he was trying to change to another host. Looks like not successful yet. Gord Dibben MS Excel MVP On Fri, 24 Jul 2009 19:55:01 -0700, FSt1 wrote: thank you. it's not just me. "JLGWhiz" wrote: I got the same result. Domain registry. "FSt1" wrote in message ... Bernard, i think the xldynamic site has be hacked. both sites you posted take me to this site. http://www.123-reg.co.uk/ i check my library and all xldynamic entries take me to the above site. all other sites in my library(or at least those tested) take me to the correct and expected site. so i am posting chip persons equivilant just in case the OP has problems too. http://www.cpearson.com/excel/CFColors.htm http://www.cpearson.com/Excel/colors.aspx and please, someone else test the xldynamic site to make sure that i haven't been hacked. Regards FSt1 "Bernard Liengme" wrote: Sum or count coloured cells If it is manually coloured, see http://www.xldynamic.com/source/xld.ColourCounter.html if it is conditionally formatted, see http://www.xldynamic.com/source/xld.CFConditions.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chuckc" wrote in message ... I need to get tthe sum of cells with certain colors in a range. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to get tthe sum of cells with certain colors in a range
thanks for that info. I'll keep tabs on the site. good site. shame to see it
out of action. Regards FSt1 "Gord Dibben" wrote: Bob's been having problems for a while. Last I heard he was trying to change to another host. Looks like not successful yet. Gord Dibben MS Excel MVP On Fri, 24 Jul 2009 19:55:01 -0700, FSt1 wrote: thank you. it's not just me. "JLGWhiz" wrote: I got the same result. Domain registry. "FSt1" wrote in message ... Bernard, i think the xldynamic site has be hacked. both sites you posted take me to this site. http://www.123-reg.co.uk/ i check my library and all xldynamic entries take me to the above site. all other sites in my library(or at least those tested) take me to the correct and expected site. so i am posting chip persons equivilant just in case the OP has problems too. http://www.cpearson.com/excel/CFColors.htm http://www.cpearson.com/Excel/colors.aspx and please, someone else test the xldynamic site to make sure that i haven't been hacked. Regards FSt1 "Bernard Liengme" wrote: Sum or count coloured cells If it is manually coloured, see http://www.xldynamic.com/source/xld.ColourCounter.html if it is conditionally formatted, see http://www.xldynamic.com/source/xld.CFConditions.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chuckc" wrote in message ... I need to get tthe sum of cells with certain colors in a range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Color a Cell Based on a Range of Cells with Colors | Excel Worksheet Functions | |||
Conditional Formatting Based on Colors in a Horz Range of Cells | Excel Discussion (Misc queries) | |||
how do I return tthe location (cell) when using the max function | Excel Discussion (Misc queries) | |||
Create drop down box with the formatting of range cells colors ect | Excel Worksheet Functions | |||
Labelling bar graph-the bars in X-axis not via tthe legend | New Users to Excel |