I need a formula that will count how many cells that have "x" showing up only if another cell in the same row is "y".
For example,
I need to count how many times "sports" shows up in column B ONLY if column D has the name David in the same row.
Below is a thread I made recently that is similar to the question I have now however the link below shows how to sum. I just need to count the cells, not sum.
http://www.excelforum.com/excel-gene...-criteria.html
Bookmarks