If Formula (visible cells only)
 

Need assistance editing the following if formula in excel 2003 to only show
the count for visible cells only and ignores any hidden rows.

=IF(J2=J1,K1+1,1)

The formula checks to see if the value in J2 equals J1, if true a + 1 is
added from K1 and entered into cell K2. If false the count is returned to 1.

The formula is entered K2:K2211. See below:

K2: =IF(J2=J1,K1+1,1)
K3: =IF(J3=J2,K2+1,1)
K4: =IF(J4=J3,K3+1,1)

Any help is appreciated.