I have added a sceenshot of the original file from which the example was created. I realized from further testing that you cannot utilize merged cells within a table, therefore the example I sent you isn't relevant. I have attached a screen shot of the spreadsheet in its original form.

You will see in Column A-D, there are rows containing duplicate data. These were the rows that I previously had merged, mainly just for formatting purposes. The first issue is the calculation in D:29 - I need this formula to only calculate unique values listed in D6:D25 rather than counting duplicate values and inflating the total amount. Formula currently used:

** =SUM(D6:D25)**
The next issue deals with the data validation selections in Column F6:F25. There are 4 text selections in a dropdown list. The summation boxes at the bottom labeled "Positive", "Negative", "No Policy Posted" and "Not Mentioned" use the following formula:

**=COUNTIF(F6:F25, "Negative")****. **This calculation is okay as I need to know the total number of coverage status indications even if there are duplicates. However, the "Lives" summation adjacent to the "Policy" summation in G:29 uses the following formula:

**=SUMIF(F6:F25, "Negative", $D$6:$D$25)****. **I need this formula to only calculate the value once for duplicate entries in Column A. As it is now, the totals listed are inflated due to being counted for each data validation selection.

I hope I have explained this more clearly. I can forward the actual excel file to anyone willing to help come up with a solution. I prefer a formula over a macro, but will take whatever is needed to produce the desired result.