PC Review


Reply
Thread Tools Rate Thread

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.

Thanks in advance for your help!
 
Reply With Quote
 
 
 
 
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nesting COUNTIF for multiple criteria in multiple columns NeedExcelHelp07 Microsoft Excel Worksheet Functions 1 12th Dec 2007 06:47 PM
RE: match multiple criteria ina range from multiple criteria multiplet =?Utf-8?B?Ukc=?= Microsoft Excel Worksheet Functions 0 27th Sep 2007 05:24 AM
Countif using format criteria not number criteria? =?Utf-8?B?UnVtYmxhNzY=?= Microsoft Excel Worksheet Functions 1 20th Apr 2005 05:38 AM
Countif using format criteria....not number criteria? =?Utf-8?B?VHJveQ==?= Microsoft Excel Worksheet Functions 1 20th Apr 2005 04:50 AM
Countif with multiple criteria and multiple worksheets =?Utf-8?B?Sko=?= Microsoft Excel Worksheet Functions 1 28th Dec 2004 07:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:31 AM.