**SOLVED** Form Calculation

hi I have questionnaire where each question has 4 possible answers. Each answer is in a category A,B,C,D
Would any one know how to create a calculation to calculate the result based on the category. Example in excel you would use SUMIF function, so SUMIF the answer is A. Then you would know how many A's or B's, C's, D's have been selected.

I have included a sample of the questions in an excel spreadsheet