Alaska, I don't think you can use COUNTIF for this function. As I understand it, you want to count the rows in 2014!$B:$C where two conditions apply, a certain value in B and a certain value in C. The way you have it, using two COUNTIFs, it counts all the times the name appears in column B, and then adds to it the number of times "Merrick" appears in column C.
For this you probably need COUNTIFS....yeah, I think that works. Take a look at the attached. I left your formula in column B for comparison, and added COUNTIFS to C:E.
|