Excel formula
 

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

Excel formula
 

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

Excel formula
 

IT DID NOT WORK.

"akphidelt" wrote:

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

Excel formula
 

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.

"almacarrillo" wrote:

IT DID NOT WORK.

"akphidelt" wrote:

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

Excel formula
 

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

Try =COUNTIF(INDIRECT("D9:D6369"),33)
--
David Biddulph

"akphidelt" wrote in message
...
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

Excel formula
 

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..

"akphidelt" wrote:

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.

"almacarrillo" wrote:

IT DID NOT WORK.

"akphidelt" wrote:

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