Excel formula

[almacarrillo]

why does my formula change when I add data example
FORMULA BEFORE ADDING DATA =COUNTIF(D96369,33)
FORMULA AFTER DATA IS ADDED TO THE WORKSHEET =COUNTIF(D2426369,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

 

[akphidelt]

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]

IT DID NOT WORK.

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.

 

[akphidelt]

well, im lost... you'll have to explain a little bit more, because I don't
understand how a formula magically jumps. Where is the formula located, how
many rows of data do you have, etc.

 

[David Biddulph]

But the OP isn't not copying and pasting down, it's data being inserted.

Try =COUNTIF(INDIRECT("D96369"),33)

 

[almacarrillo]

THE ROWS OF DATA DEPEND BECAUSE EVERY DAY I ADD DATA TO IT.DATA STARTS ON ROW
11 AND THE FORMULAS ARE ON ROW 2,3,4,5 & 6 i WOULD LIKE FOR YOU TO SEE THE
WORKBOOK THAT I HAVE..