If you just want to count all the categories, create a small table like this...
H
I
1
 Assay
1
2
 BUN
35
3
 Cholesterol
62
4
 Creatinine
67
5
 Glucose
193
6
 HDL
25
7
 LDL
19
8
 Raw Abs
476
9
 Triglycerides
34
10
 Uric Acid
41


I1=COUNTIF($B$2:$B$1478,H1) copied down

If you want this on another sheet, the formula would be...
=COUNTIF('Test%20Result(1)(1)'!$B$2:$B$1478,A1)