If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




How do I count shaded cells
I have built a scheduling templet and would like to be able to count the
number of cells that shaded. Where shaded cells represent hours worked. Any ideas? 
Ads 
#2




Randy, have a look here
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 "Randy" > wrote in message ... >I have built a scheduling templet and would like to be able to count the > number of cells that shaded. Where shaded cells represent hours worked. > Any > ideas? 
#3




Randy,
There is a counting solution at http://xldynamic.com/xld.ColourCounter.html which counts coloured cells. If you mean shaded as in pattern, it could be amended to that as well.  HTH RP (remove nothere from the email address if mailing direct) "Randy" > wrote in message ... > I have built a scheduling templet and would like to be able to count the > number of cells that shaded. Where shaded cells represent hours worked. Any > ideas? 
#4




Thanks,
i looked at that but had trouble when I put the counting formula into my cell. It returns a #NAME? error. My cells are in row a7:z7 so i modifed the forumal to read =SUMPRODUCT((ColorIndex(C7:Z7)=3)) I am not sure that the  mean before the second (. I do not remeber seeing these before. Any suggestions? "Paul B" wrote: > Randy, have a look here > > 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 > > "Randy" > wrote in message > ... > >I have built a scheduling templet and would like to be able to count the > > number of cells that shaded. Where shaded cells represent hours worked. > > Any > > ideas? > > > 
#5




Thanks bob,
i tried that but get a #NAME? error. I took the forumal at the site you sent and set up for my sheet as below =SUMPRODUCT((ColorIndex(C7:Z7)=3)) Any suggestion on what I may have done wrong? Thanks Randy "Bob Phillips" wrote: > Randy, > > There is a counting solution at http://xldynamic.com/xld.ColourCounter.html > which counts coloured cells. If you mean shaded as in pattern, it could be > amended to that as well. > >  > > HTH > > RP > (remove nothere from the email address if mailing direct) > > > "Randy" > wrote in message > ... > > I have built a scheduling templet and would like to be able to count the > > number of cells that shaded. Where shaded cells represent hours worked. > Any > > ideas? > > > 
#6




You have to install the UDF first, copy the code and paste into a module in
the workbook or make an addin by pasting into module in a new wrokbook and save as ColorIndex.xla, then restart excel and check it under tools>addins Regards, Peo Sjoblom "Randy" wrote: > Thanks, > > i looked at that but had trouble when I put the counting formula into my > cell. It returns a #NAME? error. > > My cells are in row a7:z7 > > so i modifed the forumal to read > > =SUMPRODUCT((ColorIndex(C7:Z7)=3)) > > I am not sure that the  mean before the second (. I do not remeber seeing > these before. > > Any suggestions? > > > "Paul B" wrote: > > > Randy, have a look here > > > > 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 > > > > "Randy" > wrote in message > > ... > > >I have built a scheduling templet and would like to be able to count the > > > number of cells that shaded. Where shaded cells represent hours worked. > > > Any > > > ideas? > > > > > > 
#7




Sorry I gave you the wrong reference i used this link to find a formula
http://www.xldynamic.com/source/xld.ColourCounter.html "Randy" wrote: > Thanks bob, > > i tried that but get a #NAME? error. > > I took the forumal at the site you sent and set up for my sheet as below > > =SUMPRODUCT((ColorIndex(C7:Z7)=3)) > > Any suggestion on what I may have done wrong? > > Thanks > Randy > "Bob Phillips" wrote: > > > Randy, > > > > There is a counting solution at http://xldynamic.com/xld.ColourCounter.html > > which counts coloured cells. If you mean shaded as in pattern, it could be > > amended to that as well. > > > >  > > > > HTH > > > > RP > > (remove nothere from the email address if mailing direct) > > > > > > "Randy" > wrote in message > > ... > > > I have built a scheduling templet and would like to be able to count the > > > number of cells that shaded. Where shaded cells represent hours worked. > > Any > > > ideas? > > > > > > 
#8




Did you put the code in a normal code module, not a sheet module?
 HTH RP (remove nothere from the email address if mailing direct) "Randy" > wrote in message ... > Sorry I gave you the wrong reference i used this link to find a formula > > http://www.xldynamic.com/source/xld.ColourCounter.html > > "Randy" wrote: > > > Thanks bob, > > > > i tried that but get a #NAME? error. > > > > I took the forumal at the site you sent and set up for my sheet as below > > > > =SUMPRODUCT((ColorIndex(C7:Z7)=3)) > > > > Any suggestion on what I may have done wrong? > > > > Thanks > > Randy > > "Bob Phillips" wrote: > > > > > Randy, > > > > > > There is a counting solution at http://xldynamic.com/xld.ColourCounter.html > > > which counts coloured cells. If you mean shaded as in pattern, it could be > > > amended to that as well. > > > > > >  > > > > > > HTH > > > > > > RP > > > (remove nothere from the email address if mailing direct) > > > > > > > > > "Randy" > wrote in message > > > ... > > > > I have built a scheduling templet and would like to be able to count the > > > > number of cells that shaded. Where shaded cells represent hours worked. > > > Any > > > > ideas? > > > > > > > > > 
#9




Thanks Peo,
I have to admit i have never written any code in xcell outside formulas. Any suggestion on where I could find info to what you suggested? Randy "Peo Sjoblom" wrote: > You have to install the UDF first, copy the code and paste into a module in > the workbook or make an addin by pasting into module in a new wrokbook and > save as ColorIndex.xla, then restart excel and check it under tools>addins > > Regards, > > Peo Sjoblom > > "Randy" wrote: > > > Thanks, > > > > i looked at that but had trouble when I put the counting formula into my > > cell. It returns a #NAME? error. > > > > My cells are in row a7:z7 > > > > so i modifed the forumal to read > > > > =SUMPRODUCT((ColorIndex(C7:Z7)=3)) > > > > I am not sure that the  mean before the second (. I do not remeber seeing > > these before. > > > > Any suggestions? > > > > > > "Paul B" wrote: > > > > > Randy, have a look here > > > > > > 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 > > > > > > "Randy" > wrote in message > > > ... > > > >I have built a scheduling templet and would like to be able to count the > > > > number of cells that shaded. Where shaded cells represent hours worked. > > > > Any > > > > ideas? > > > > > > > > > 
#10




You don't have to write it, it is all on the web page. Just copy and paste
it.  HTH RP (remove nothere from the email address if mailing direct) "Randy" > wrote in message ... > Thanks Peo, > > I have to admit i have never written any code in xcell outside formulas. > Any suggestion on where I could find info to what you suggested? > > Randy > > "Peo Sjoblom" wrote: > > > You have to install the UDF first, copy the code and paste into a module in > > the workbook or make an addin by pasting into module in a new wrokbook and > > save as ColorIndex.xla, then restart excel and check it under tools>addins > > > > Regards, > > > > Peo Sjoblom > > > > "Randy" wrote: > > > > > Thanks, > > > > > > i looked at that but had trouble when I put the counting formula into my > > > cell. It returns a #NAME? error. > > > > > > My cells are in row a7:z7 > > > > > > so i modifed the forumal to read > > > > > > =SUMPRODUCT((ColorIndex(C7:Z7)=3)) > > > > > > I am not sure that the  mean before the second (. I do not remeber seeing > > > these before. > > > > > > Any suggestions? > > > > > > > > > "Paul B" wrote: > > > > > > > Randy, have a look here > > > > > > > > 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 > > > > > > > > "Randy" > wrote in message > > > > ... > > > > >I have built a scheduling templet and would like to be able to count the > > > > > number of cells that shaded. Where shaded cells represent hours worked. > > > > > Any > > > > > ideas? > > > > > > > > > > > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Selecting shaded cells in a row  Al  Excel Worksheet Functions  5  January 25th 05 05:31 AM 
Count noncolored cells  Ken G  Excel Discussion (Misc queries)  3  January 2nd 05 12:42 PM 
Count number of shaded cells  Maddoktor  Excel Discussion (Misc queries)  2  December 20th 04 08:35 PM 
Shaded cells won't print shaded  Linda C  Excel Worksheet Functions  2  December 14th 04 10:42 PM 
Count cells with data  shoiley  New Users to Excel  5  November 28th 04 07:23 PM 