Need Help FAST with COUNTIF Formula

Jul 15, 2010
Reaction score
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!


Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question