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