You need to make your cell references absolute by using the $ signs. So the
first formula should be

=Countif($D$9:$D$6369,33)

Then when you paste it on down it will keep the correct array otherwise it
will increment to D10, D11, etc.

"almacarrillo" wrote:

why does my formula change when I add data example
FORMULA BEFORE ADDING DATA =COUNTIF(D9:D6369,33)
FORMULA AFTER DATA IS ADDED TO THE WORKSHEET =COUNTIF(D242:D6369,33)
This is the data that is entered in worksheet
10 080501 S-BU-99-M 46 0277 DOLLEW 5/7/2008 9:23
10 080501 S-BU-99-M 46 0278 ALBGRA 5/6/2008 14:21