+ Reply to Thread
Results 1 to 5 of 5

Countifs same data text and same cell background color?

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    santa ana, ca
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Countifs same data text and same cell background color?

    I'm looking to find a macros code to "count if" same cell background color, same text field in column d4:d10000, and same text field in f4:f10000.

    This sheet "summary.xlsm" will be gathering information from an "inventory.xlsx" sheet1.


    Someone please help

    or

  2. #2
    Registered User
    Join Date
    08-17-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    82

    Re: Countifs same data text and same cell background color?

    Hello,

    You cannot do that without a VBA code. In the process of trying to help you I found out that seems to exist a third party add-in that allows you to Countif and Sumif by background color and fontcolor.
    Now, the problem is that I was not able to find out any..therefore I'm not entirely sure if exists. But maybe someone knows something that can assist you with that. That's something that can come up handy

    Nevertheless I would suggest you to move this thread to the "Excel Programming / VBA / Macros" section. I'm sure they can easily help you with a code.


    Kind Regards,
    FCarv

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    santa ana, ca
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Countifs same data text and same cell background color?

    Thank you,
    So do I create new thread with copy paste?

    Thank you.

  4. #4
    Registered User
    Join Date
    08-17-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    82

    Re: Countifs same data text and same cell background color?

    I thought you could move it by yourself.

    No, don't do that - I believe that would violate rule #5

    "5. Don't duplicate posts. We have seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one. "

    Just ask a moderator to move your thread to the appropriate forum.


    Rgds,
    FCarv

  5. #5
    Registered User
    Join Date
    09-07-2012
    Location
    santa ana, ca
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Countifs same data text and same cell background color?

    Ok I will delete this thread then...


    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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