Results 1 to 4 of 4

Thread: [RESOLVED] Count colored cells in a filtered column

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,385

    Resolved [RESOLVED] Count colored cells in a filtered column

    Column X in my worksheet is formatted as General and in that column some of the cells are blank, some are numbers, and some are numbers with a fill color, and all the fill colors are the same.

    I need a formula that will return the count of the visible cells that have a fill color, even when the rows are filtered. For example if no rows are filtered and there are 4 filled cells the formula should return 4 and after filtering if there are only 2 visible filled cells the formula should return 2.

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,275

    Re: Count colored cells in a filtered column


  3. #3
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    3,847

    Re: Count colored cells in a filtered column

    Quote Originally Posted by jdc2000 View Post
    Yep, that's the same link i found. and it works!
    But it's convoluted, since it involves a Makro4-Function, meaning the Workbook must be saved with Macros (xlsm)
    Another downside is, that there is no "automatic" recalculating/refreshing if, say a backcolor of a cell is changed

    Probably easier to save the Workbook with Macros, and write a custom public Function in a module, which then you can use like any other Excel-Function
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  4. #4

Posting Permissions

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



Click Here to Expand Forum to Full Width