creating an auto counting sheet

Hi All,

I will appreciate if some one can help me with creating an auto counting
sheet. We have an excel file with two sheets "05 JUL" and "COUNT".

Data will be like

DATA TKT # 1 TKT # 2 TKT # 3 TKT # 4 TKT # 5
PRO 6071 6072 6073 6074
REW 6075 6076
PRO 6077 6078 6079
REV 6080
REW 6081 6081 6081 6081 6081


The formula to be applied on excel "COUNT" to auto count all the
REW, PRO and REV tickets like below.

DATE 05-Jul

PRO 7
REV 1
REW 7

Thanks I will try to provide the image as well.
Ayaz

this should get you started
formulas in yellow cells