With Headings Minor, Major and Critical, you can use:
Formula: copy to clipboard
=COUNTIFS($A$2:$A$14,$E2,$B$2:$B$14,F$1)


But you should probably look at Pivot Tables


Regards, TMS