Dear All,
Good Morning from Qatar.
I am trying to count a specific color cells in a Row. I am able to do it for column by using =subtotal(103, range) then by filter via Color but unable to do in multiple rows.
file attached with thread for reference.
In the Sheet Named Column formula is working but unable to do the same in Sheet Named Row.
Last edited by kskhan; 06-29-2019 at 12:24 PM.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Thanks for the Quick Response & Sorry for being late in taking the action.Originally Posted by Pepe Le Mokko
Please check now & do let me know if I am unable to provide the info. required.
Regards,
Kashif
Regards,
Kashif
Thanks, and BTW,please don't quote entire posts unnecessarily. They are just clutter and make threads hard to read.
Use the "Quick reply" instead
Thanks
=CountColor(A1:A50,B2)
VBA:
PHP Code:Function CountColor(Rng As Range, RngColor As Range) As Integer
Dim Cll As Range
Dim Clr As Long
Clr = RngColor.Range("A1").Interior.Color
For Each Cll In Rng
If Cll.Interior.Color = Clr Then
CountColor = CountColor + 1
End If
Next Cll
End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks