Glad you got it straightened out! Thanks for letting us know. We appreciate
feedback!

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Due to the nature of the data, I was copying pieces of it into another
spreadsheet. Doing this, and posting them as values, rather than the
formulas used to fill them and saw that I was getting non whole numbers
(which were expected). On a whim, I used ROUNDUP, since any fraction
might
as well be another whole unit, and after using this I now have the correct
numbers.

Thanks for all your help, both you and others. Trying to send you the
data
actually helped me fix it!

"T. Valko" wrote:

Ok, there's definitely a problem with your data.

I see other replies have made some suggestions but at this point I'd need
to
see the data first hand to figure out what the problem is.

If you can/want to send a copy of the file I'll take a look. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious. If the file is 1mb in size, zip it.

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
I get just "0" as a value with this.

"T. Valko" wrote:

What do you get with this formula:

=SUMPRODUCT(--(ISNUMBER(Current!D1:D10000)),--(Current!D1:D10000=180))


--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Hi there excel gurus. I'm stumped as to how to rectify a bug in
Excel2000
with the COUNTIF function. Simply put, the number is not coming up
correctly. I have a very simple function:

=COUNTIF(Current!D1:D10000,"=180")

which should give me everything in the column with a value of 180 or
greater, however, the number is off by a few. I'm getting 1531 when
there
1537 records when I simply use the cursor to count. I found a
Knowledge
base
article that was possibly on it, but was unable to make the formula
work
based on their suggestions. The last line of the data currently
ends
at
3700
something, but it will continue to grow, thus my 10k figure. Even
changing
this to the last line does not alter the incorrect count.

Please advise!