Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2009
    Thanked 0 Times in 0 Posts
    I have an excel sheet with 2 columns of data - all text rather than numeric. The first column contains 4 different text values: A, IO PO and S. The second column either contains a Y or a blank. I would like to count the number of Ys in the second column against the 4 categories in the first column - ie for those recorded as A in the 1st column, how many of these recorded Y in the second column?

    Should I be using an array formula, or some version of COUNTIF?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    Welcome to the Lounge!

    If you're using Excel 2007, you can use the new COUNTIFS function. For example, if your data are in A2:B100:


    In Excel 2003 and before, you have to use a different method. For example, if your data are in A2:B100:


    This is a "normal" formula, not an array formula (the array aspect is implicit in SUMPRODUCT).

Posting Permissions

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