In the example attached, I wanted to know if there was a formula that would count the colors of each cell per row.
Or if there was another way to note cells so that they may be counted.
Thanks for any help.
Nick
In the example attached, I wanted to know if there was a formula that would count the colors of each cell per row.
Or if there was another way to note cells so that they may be counted.
Thanks for any help.
Nick
Hi avidcat,
Unfortunately, Excel doesn't native function to do that. However, there some very useful UDFs available that can do this job very well
Please check out this link below. This UDF can be used to count colored cells and also do the summation.
http://www.ablebits.com/office-addin...nt-cells-color
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Use the following code..
but you sheet know the Colorindex of the color to be counted..
Please Login or Register to view this content.
Don't forget to click *
Please Login or Register to view this content.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks