Countif with Multiple Criteria

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

  1. CynthiaSCE

    CynthiaSCE

    Joined:
    Jul 15, 2010
    Messages:
    3
    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
    Messages:
    3
    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:
    295
    Zuzana Fabian
    Mar 7, 2006
  2. godonnygo

    Excel: COUNTIF/Data questions

    godonnygo, Aug 9, 2006, in forum: Windows XP
    Replies:
    10
    Views:
    659
    klaus
    Aug 13, 2006
  3. yetifem

    countif function

    yetifem, Jun 4, 2007, in forum: Windows XP
    Replies:
    3
    Views:
    364
    yetifem
    Jun 17, 2007
  4. Kiwi Berg
    Replies:
    1
    Views:
    581
    Kiwi Berg
    Dec 23, 2008
  5. snapej1

    COUNTIF & SUBTOTALS

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

Share This Page