PDA

View Full Version : Count Colored Cells Using Excel Formula


mahmoud-lee
06-15-2013, 10:44 AM
I want to count these cells colored by the formula without the code
Excel Fox
06-15-2013, 10:53 AM
Why not a VBA code solution? Why are you looking for a formula based solution?
mahmoud-lee
06-15-2013, 10:59 AM
Because I love formulas
Is solved difficult formulas ?
I've done something like this
=COUNTIF(D2:L2;">"&$L$2)
But I want the best from you
Excel Fox
06-15-2013, 11:14 AM
The formula you've mentioned above gives the answer you are expecting. So is this question something that you want to do, or just curious to know if it is possible through formula.
mahmoud-lee
06-15-2013, 11:37 AM
I want another way!
Is there no other way better than this?