D
Dave
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!D110000,">=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!
with the COUNTIF function. Simply put, the number is not coming up
correctly. I have a very simple function:
=COUNTIF(Current!D110000,">=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!