automated_count_value in excel

See more:

MS-Excel

# CLAIMS CLAIM TYPE
2 HCFA
5 HCFA
2 MISC
5 DEN
3 MISC
4 UB
6 HCFA
4 HCFA
1 DEN
5 UB
6 HCFA
2 MISC
1 MISC

MISC HCFA UB DEN INVOICE TOTAL
0 0 0 0 0 0

Dear All,
I need automated logic for count no. of claims on the basis of their cliam type.
Since intitally I've given all the records in second sheet is zero.Since there is no any screen shot facility so I'm having to just paste my query like this.Now I have to manually count no. of HCFA'S claims,MISC'S claims and so on.So what logic should be used to count these record.


thanks and regards,,
ravindra bisht