Countif Returing Incorrect Result

  • Thread starter Thread starter kcb
  • Start date Start date
K

kcb

I am experiencing a problem with my countif formula, and am not reall
sure what is causing it.

Here is the background data:

I have a data sheet that contains a database dump of company number an
batch number (this is a unique number assigned to each of the tim
batches they submit). This is just a partial example of the listing
there are over 1500 rows in the list

Co batch #
001C38 203,040
001C39 199,303
001C40 202,487
001C42 199,950
001C42 201,961
001E01 199,647
001E01 199,657
001E01 199,663

I have created the following formula to count how many times eac
company appears in the list.

=COUNTIF('[Payroll Data Sheet.xls]Batches Received'!$A:$A,$B12)

Where the data sheet contains the list above and B12 contains th
specific Company I am looking for.

Here is the problem:

Some of the formulas are returning incorrect data. It appears t
happen when the company number contains 001E01, or 001400, or 010100.
All of the others return just fine.

I have searched the microsoft site, and have not had any luck...thank
for your hel
 
Hi
try formating the company column as 'Text'. Currently these values are
seen as numbers.
 
Back
Top