Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 05, 08:37 PM
Randy
 
Posts: n/a
Default 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?

  #2   Report Post  
Old January 31st 05, 08:49 PM
Paul B
 
Posts: n/a
Default

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   Report Post  
Old January 31st 05, 08:57 PM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old January 31st 05, 09:03 PM
Randy
 
Posts: n/a
Default

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   Report Post  
Old January 31st 05, 09:09 PM
Randy
 
Posts: n/a
Default

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   Report Post  
Old January 31st 05, 09:15 PM
Peo Sjoblom
 
Posts: n/a
Default

You have to install the UDF first, copy the code and paste into a module in
the workbook or make an add-in by pasting into module in a new wrokbook and
save as ColorIndex.xla, then restart excel and check it under toolsadd-ins

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   Report Post  
Old January 31st 05, 09:17 PM
Randy
 
Posts: n/a
Default

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   Report Post  
Old January 31st 05, 09:38 PM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old January 31st 05, 09:45 PM
Randy
 
Posts: n/a
Default

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 add-in by pasting into module in a new wrokbook and
save as ColorIndex.xla, then restart excel and check it under toolsadd-ins

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   Report Post  
Old January 31st 05, 09:57 PM
Bob Phillips
 
Posts: n/a
Default

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 add-in by pasting into module in a new wrokbook

and
save as ColorIndex.xla, then restart excel and check it under

toolsadd-ins

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?







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shaded cells won't print shaded Linda C Excel Worksheet Functions 3 February 19th 17 11:41 PM
Selecting shaded cells in a row Al Excel Worksheet Functions 5 January 25th 05 05:31 AM
Count non-colored 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
Count cells with data shoiley New Users to Excel 5 November 28th 04 07:23 PM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017