Hello all,
I have a small file and I need to count all filled cells and all red color cells in range C2:J17.
we have the same table for each day. is possible to have a piece of code in the ActiveSheet?
test file added for your reference,
Thank you very much for your help.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Please Login or Register to view this content.
In E24 Cell
=CountByColor(D24,C2:J17)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixtsense,
thanks a lot for your help!
is possible to have the result (pic attached) in the same place, automatically, for each sheet? I mean the future filled sheets..?
With regards,
John
Please Login or Register to view this content.
Excellent!
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks