Hi,
I am working on an excel document and am having difficulty figuring out how to do something. Here is what I have:
1. 80 rows of student names.
2. Multiple columns of data for each student.
3. One of the columns is their race.
4. Another column has a "yes" or "no" response.
I want to get the count of students for each race AND who have a "yes" response.
I have played around with the Countif function and can get a count of each of the races but cannot figure out how to do both.
Thanks in advance!
I am working on an excel document and am having difficulty figuring out how to do something. Here is what I have:
1. 80 rows of student names.
2. Multiple columns of data for each student.
3. One of the columns is their race.
4. Another column has a "yes" or "no" response.
I want to get the count of students for each race AND who have a "yes" response.
I have played around with the Countif function and can get a count of each of the races but cannot figure out how to do both.
Thanks in advance!