How to prevent duplicate wildcard sum values

[brianlg]

Hello.

I have a formula to find unique values in a column. I fill this down to a row where it will never exceed. Therefore, I have a lot of blank values after the last unique value.

When I am doing a sumifs off these values, I use a wildcard to sum values based on the cell to the left. When I do this on my blank cells, it repeats basically the total value of the cell since it sums everything with *(blank)* as a wildcard.

I would like this to happen once, as it basically acts as a grand total value.

How do I prevent this from duplicating?

Ex. data:



[TABLE="width: 500"]
<tbody>[TR]
[TD]Color[/TD]
[TD]Sales[/TD]
[TD]% of total[/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]100[/TD]
[TD]58.8[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]50[/TD]
[TD]29.4[/TD]
[/TR]
[TR]
[TD]Grey[/TD]
[TD]20[/TD]
[TD]17.8[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]170[/TD]
[TD]100.0[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]170[/TD]
[TD]100.0[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]170[/TD]
[TD]100.0[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]170[/TD]
[TD]100.0[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]170[/TD]
[TD]100.0[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]170[/TD]
[TD]100.0[/TD]
[/TR]
</tbody>[/TABLE]

The number of entries in col a will vary depending on what data I dump into the data tab, so I need the excess formulas and blanks. I just need the values in B and C to stop after one blank and not repeat, ie, show blank as well