well thats it cpearson or otherways like it are the way to count colours!
why are they coloured whats the logic?
another way in excel 2007 tho
assuming the cells to be counted are the same colour say yellow and have something in them (not formulas)
say range a2:a10
in b1 put =SUBTOTAL(103,A2:A10)
filter a2:a10 by the colour
b1 will be the count of cells coloured yellow that are not blank
Last edited by martindwilson; 03-26-2012 at 08:39 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks