+ Reply to Thread
Results 1 to 5 of 5

How to count Colored Cell in a Row

  1. #1
    Registered User
    Join Date
    06-10-2016
    Location
    Qatar
    MS-Off Ver
    2016
    Posts
    18

    How to count Colored Cell in a Row

    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.
    Attached Files Attached Files
    Last edited by kskhan; 06-29-2019 at 12:24 PM.

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    9,249

    Re: How to count Colored Cell in a Row

    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.

  3. #3
    Registered User
    Join Date
    06-10-2016
    Location
    Qatar
    MS-Off Ver
    2016
    Posts
    18

    Re: How to count Colored Cell in a Row

    Quote Originally Posted by Pepe Le Mokko View Post
    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.
    Please check now & do let me know if I am unable to provide the info. required.


    Regards,
    Kashif
    Regards,
    Kashif

  4. #4
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    9,249

    Re: How to count Colored Cell in a Row

    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

  5. #5
    Registered User
    Join Date
    09-25-2016
    Location
    rotterdam
    MS-Off Ver
    2014
    Posts
    4

    Re: How to count Colored Cell in a Row

    =CountColor(A1:A50,B2)

    VBA:
    PHP Code: 
    Function CountColor(Rng As RangeRngColor 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 

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1