# Countif with Multiple Criteria

New Member
Join Date: Jul 2010
Posts: 3

 15th Jul 2010
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.

New Member
Join Date: Sep 2010
Posts: 3

 1st Sep 2010
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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post NeedExcelHelp07 Microsoft Excel Worksheet Functions 1 12th Dec 2007 06:47 PM =?Utf-8?B?Ukc=?= Microsoft Excel Worksheet Functions 0 27th Sep 2007 05:24 AM =?Utf-8?B?UnVtYmxhNzY=?= Microsoft Excel Worksheet Functions 1 20th Apr 2005 05:38 AM =?Utf-8?B?VHJveQ==?= Microsoft Excel Worksheet Functions 1 20th Apr 2005 04:50 AM =?Utf-8?B?Sko=?= Microsoft Excel Worksheet Functions 1 28th Dec 2004 07:37 PM

Features