+ Reply to Thread
Results 1 to 3 of 3

Need help with CountIF when counting rows of 2 columns and comparing a 3rd columns value

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Unhappy Need help with CountIF when counting rows of 2 columns and comparing a 3rd columns value

    I need to count the number of times a customer contact is made and if that customer is a top tier customer. So for example count column A or Column B if Column C = YES. Then also count Column A and column B is Column C = NO. I have attached an example spreadsheet with some mock data if anyone can help.

    I think I need to use a COUNTIF vs a SUMPRODUCT, but I am not sure how to add in the 3rd check of Column C being a YES / NO?

    Thank you everyone.Customer Contacts per Top Tier Clients - example.xls

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,711

    Re: Need help with CountIF when counting rows of 2 columns and comparing a 3rd columns val

    I couldn't find either "YES,NO" in B column or values in D,E,F. Or I missed sth?

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help with CountIF when counting rows of 2 columns and comparing a 3rd columns val

    Sorry i should have noted that there are two workbooks in this doc. The first is the data and the second is results. I manually filled in the correct results on the 2nd workbook. I just need those numbers to be automatically calculated.

+ 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