+ Reply to Thread
Results 1 to 3 of 3

Counting Two criteria in two columns within Data Validated cells.

  1. #1
    Registered User
    Join Date
    08-11-2012
    Location
    Boston, MA
    MS-Off Ver
    Google Spreadsheet
    Posts
    1

    Counting Two criteria in two columns within Data Validated cells.

    I'm attempting count for two different criteria within two different columns in cells that have a list of Data Validation terms. Is this impossible?

    1. The two columns I'm trying to count are on the same sheet.
    2. The two columns I'm trying to count have a list of Data Validation terms.

    Here is exactly what I want to count:

    Column A has these Data Validation terms: Break Up, Hired, Offer
    Column B has these Data Validation terms: Support, AM, IMC

    I want to count all the entries that prove true for "Support" and "Offer". I've tried just about everything available on the web. Does anybody have any suggestions?

    Thank you!

    Dave

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,317

    Re: Counting Two criteria in two columns within Data Validated cells.

    Look e.g. for pivot table.

    Otherwise post an exel example, without confidentional information.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,987

    Re: Counting Two criteria in two columns within Data Validated cells.

    you dont specify what version of excel you have, but it its 2007 or greater, do try using countifS()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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