Count
 

have a spreadsheet with 11792 rows containing unique numbers from .01 to
$1,000,000 n column D.
What I want to do is capture totals of ranges.

For example - how many cells contain data from 0.01 to 500 in column D
Then the next range would be how many cells contain data from 501 to 10,000
and so one

Do I need to use exact data, ex 500 but there is no cell with actual 500 but
there is 499.

I've tried Countif but I must be doing something wrong because I get
negative numbers.

Thanks

Count
 

Joey,

Have you tried CountA?

Rob

"Joey" wrote in message
...
have a spreadsheet with 11792 rows containing unique numbers from .01 to
$1,000,000 n column D.
What I want to do is capture totals of ranges.

For example - how many cells contain data from 0.01 to 500 in column D
Then the next range would be how many cells contain data from 501 to
10,000
and so one

Do I need to use exact data, ex 500 but there is no cell with actual 500
but
there is 499.

I've tried Countif but I must be doing something wrong because I get
negative numbers.

Thanks