Solved Solved: Excel Formula Question

[misterjw]

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!

 

[WendyM]

Hi misterjw. welcome to TSG.

You can do it with a sumproduct formula:

=SUMPRODUCT((A1:A80="race")*(B1:B80="yes"))

Of course you'll need to replace your ranges and the "race" to fit your spreadsheet. Hope that helps.

 

[misterjw]

You are the best! Thanks for your help. I had played and played with various formulas but couldn't figure it out. Thanks!