Count by Category

Hello,

Try C3, copy down & across.

=SUMPRODUCT(--($I$3:$I$35=LOOKUP("zzzzz",$A$3:$A3)),--($J$3:$J$35=C$2),--($K$3:$K$35=$B3))

If you are on XL2007 or later,

=COUNTIFS($I:$I,LOOKUP("zzzzz",$A$3:$A4),$J:$J,C$2,$K:$K,$B4)