Collecting data from auto- generated excel file

An excel file is auto-generated by a biochemistry machine that perform blood tests.
The file has a sheet named "test results" which contains detailed information about the tests
patient ID, Assay,Result ...etc.
I want that all tests performed be counted and grouped into one a table in a different sheet
i.e; the total number of tests performed under the name "glucose" for example.

Thank you

Originally Posted by FDibbins

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)

But why to use 1476
what to do if the file is more extended and contains much further rows?

thanks to you and to popipipo
both functions work well