How do I count cells with a specific cell shading?

  • Thread starter Thread starter Guest
  • Start date Start date
That works a treat! Thanks.
However, I have an additional complication in that I only want to count
cells of a specific colour AND with non-zero values. I'm afraid my VBA isn't
up to it!
Any idea?
Ray Mount
 
It is counted by VBA, the VBA returns an array of matching colours, it is
the SP formula. So use something like

=SUMPRODUCT(--(C1:C1000<>0),--(ColorIndex(C1:C1000)=Colorindex(A1))

where A1 is coloured with your test colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Spot one once again!
Thanks very much - it has saved me a lot of effort now and in the future.
Ray Mount
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shade a Cell 7
Comparison of columns using Conditional Formatting 3
SUMIF based on cell shading 1
How can I count the number of cells with a particular color/shade 2
Count Format Types 3
Cell Shading 2
How do I count shaded cells 19
Calculating percentage of Shaded Cells in a row 1

Back
Top