Error in Cell Counting

Hello,

I'm hoping to receive some help for a code I've been using that is suddenly working very strangely. Attached is an example workbook and below is the code I've been using to format it. The code alphabetizes and counts the number of entries for a given 'FC4' code and then deletes the duplicates. However, now it seems to be incorrectly counting some lines.

For example in the attached example workbook, you can 'manually' count 2741 entries for the CHA117 entry. However, my code is counting that entry to be 2746.

The peculiar thing is that the code does seem to count some entries correctly, but on other lines it spits out an inaccurate count (the inaccurate count is always higher than the accurate count).

I think my problem must be with my SUMIF function, but I can't figure it out properly...

Any thoughts/advice would be greatly appreciated!

Thank you!

Please Login or Register  to view this content.