Countif with Multiple Criteria

Windows XP Discussion in 'Windows' started by CynthiaSCE, Jul 15, 2010.

  1. CynthiaSCE

    CynthiaSCE

    Joined:
    Jul 15, 2010
    Likes Received:
    0
    Hello everyone,

    I need help fast. I am creating a Summary Page (Worksheet 1) and would like to pull data from Worksheet 2. My Worksheet 2 has various columns and many rows. In Column A, I have a list of employee names, for example: Henderson, Craig. In Column G, I have a list of Yes or No corresponding to the employee name. I need a countif formula to count the number of "No" in Column G, but ONLY if it matches a specific name in Column A "Henderson".

    What will be the countif formula to be calculated in my Summary Page (Worksheet 1)? The data will be pulled from Worksheet 2.

    Thanks in advance for your help!
     
    CynthiaSCE, Jul 15, 2010
    #1
    1. Advertisements

  2. CynthiaSCE

    pcehunter

    Joined:
    Sep 1, 2010
    Likes Received:
    0
    easiest would be to make a reference column and combine column A & G (you can use concatenate formula or just =A#&G#, then on summary page your countif formula would be on your new ref column (which we'll pretend if column 'H' and your names on summary page start we'll pretend they start in A2)


    =countif(worksheet 2!H$2:H$99,A2&"No")

    Hope this helps
     
    pcehunter, Sep 1, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Zuzana Fabian
    Replies:
    0
    Views:
    345
    Zuzana Fabian
    Mar 7, 2006
  2. Clueless Kerry

    Excel Excel help-sum if with multi Criteria

    Clueless Kerry, Jul 24, 2006, in forum: Microsoft Office
    Replies:
    9
    Views:
    685
    klaus
    Jul 28, 2006
  3. godonnygo

    Excel Excel: COUNTIF/Data questions

    godonnygo, Aug 9, 2006, in forum: Microsoft Office
    Replies:
    10
    Views:
    787
    klaus
    Aug 13, 2006
  4. yetifem

    Windows XP countif function

    yetifem, Jun 4, 2007, in forum: Windows
    Replies:
    3
    Views:
    401
    yetifem
    Jun 17, 2007
  5. vikraman_2k3

    Windows XP Print criteria

    vikraman_2k3, Aug 2, 2007, in forum: Windows
    Replies:
    0
    Views:
    301
    vikraman_2k3
    Aug 2, 2007
  6. petert

    Excel Excel and Percentrank Criteria Issue

    petert, Nov 26, 2008, in forum: Microsoft Office
    Replies:
    0
    Views:
    765
    petert
    Nov 26, 2008
  7. Kiwi Berg

    Excel Excel - Countif Not Working! It misses some cells.

    Kiwi Berg, Dec 22, 2008, in forum: Microsoft Office
    Replies:
    1
    Views:
    670
    Kiwi Berg
    Dec 23, 2008
  8. snapej1

    Windows XP COUNTIF & SUBTOTALS

    snapej1, Aug 20, 2009, in forum: Windows
    Replies:
    0
    Views:
    452
    snapej1
    Aug 20, 2009
Loading...