Did you try =COUNTIF($B$14:$B$26,A6,$F$14:$F$26) before adding the other variables to the "COUNTIFS" ? Looks like it should work and if you want to use countifs( ) you need additional variables from what you show. Keep trying, You'll get it!
Good Luck,
Bookmarks