Excel formula

A

almacarrillo

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
 
A

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

almacarrillo

IT DID NOT WORK.

akphidelt said:
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.
Click to expand...
 
A

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

David Biddulph

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

Try =COUNTIF(INDIRECT("D9:D6369"),33)
 
A

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