Nesting IF / COUNTIF STATEMENTS

[MARKSTRO]

Please see attached sheet.
1. I would like to make an IF statement in C2:C7 for cells in range B15:B782
that match H2:H7.

2. Then, count in range K15:K782 each cell matching $L$2 for each criteria match in B

I have attempted many formulas and cannot get it. I get close but cannot nest the two statements properly.

[NBVC]

I am not exactly sure what it is you are doing, but in your version of excel, there is a COUNTIFS function available that works with multiple conditions.

For example the formula you have in L9 might be:

=COUNTIFS($B$15:$B$782,$H$2,$K$15:$K$782,$J$2)

If that is not what you want, can you try explaining more...

[MARKSTRO]

Great solution, thanks.