I have a list of my music. I colored the font for the songs I have as RED and the songs I want, I left as default BLACK. Is there a way to Count the number for each color? I know how to filter by color, I was just hoping there was an easy way to count them.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes I actually found two solutions. One is the =SUBTOTAL(103,A2:A76) function, which will count each cell that is in the range once you filter. So all I do is filter by color and then it gives me the total.
The 2nd is found from http://www.cpearson.com/excel/colors.aspx, which I will certainly not take credit for! You simply add the .bas file (which is downlable from that site) and it gives you a number of functions that do exactly what I want as well. I use both methods for different sheets I have.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks