Counting Unique Values - Slight variations do not seem to work properly

Having a hard time troubleshooting this, might as well give it a crack here.

I have a single spreadsheet I am using to keep track of revisions, broken down into individual production facility via workbooks. Each plant has a different way of breaking down their products, but for the most part its Group 1, Group 2 etc etc. Each grouping is specific machine line.

Within each machine line there are the products themselves that are being changed. I am tracking the overall numbers on a single sheet for all plants. There is a lot of numbers I am capturing, my only concern for this inquiry is shown below:

image4.PNG

SKUs in this case are the # of different products we are revising. I am trying to get formula's setup so I can count # of products we are working on, separate from number of parts we are updating.

Within each individual plant line, I am using the following formula, based upon Line 2110:

=SUM(IF(FREQUENCY(IF(Plant1!$G$2:$G$10030=E4, IF(Plant1!$A$2:$A$10030<>"",MATCH(Plant1!$A$2:$A$10030,Plant1!$A$2:$A$10030,0))),ROW(Plant1!$A$2:$A$10030)-ROW(Plant1!$A$2)+1),1))

Based upon Group 1:

=SUM(IF(FREQUENCY(IF(Plant1!$F$2:$F$10030=B2, IF(Plant1!$A$2:$A$10030<>"",MATCH(Plant1!$A$2:$A$10030,Plant1!$A$2:$A$10030,0))),ROW(Plant1!$A$2:$A$10030)-ROW(Plant1!$A$2)+1),1))

The problem lies in the greenish line. The numbers do not add up and I am unsure why. It should read the number as 116 total (Group 1, 2 and 3 added up) but it gives me 114.

The formula for the green section is:

=SUMPRODUCT((Plant1!$A$2:$A$10030<>"")/COUNTIF(Plant1!$A$2:$A$10030,Plant1!$A$2:$A$10030&""))

I am unsure where the 2 extra's are coming from. I have no blanks, no random numbers somewhere. Everything seems lined up. The reason why I am using these formula's is because the SKU's can sometimes be a string of numbers, a string of letters, or both at the same time. Unique values was where I was going towards.

Any advice on this subject would be great or any tricks to confirm the numbers are jiving correctly would be helpful.

I don't think those numbers should necessarily add up to the same total. The overall number of different products (114) should only be equal to the sum of the number of different products per Line if each product appears in one Line exactly (not in two or more and not in zero). Can you be sure that is the case?