I want to count these cells colored by the formula without the code
I want to count these cells colored by the formula without the code
Why not a VBA code solution? Why are you looking for a formula based solution?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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
Last edited by mahmoud-lee; 06-15-2013 at 11:04 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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
I want another way!
Is there no other way better than this?
Posting Permissions
Reply With Quote
Bookmarks