I have 2 columns of data. One contains the "tier" or 1, 2, or 3. The other
column contains a weight (%). The sum of all tier "1" must = 100%. The sum
of all tier "2" for a tier 1 must sum to 100%. The sum of all tier "3" for
each tier 2 must sum to 100%. I need to validate that the weights are
correct. I've validated Tier "1" with Sumif, but I'm having trouble with
tier 2 & 3. Then I tried using VBA, but I am having difficulty. Can anyone
help with a simple approach?

Thank you!!! Sherry

Tier Weight
1 50%
2 30%
3 10%
3 90%
2 70%
1 50%
2 40%
2 60%
3 50%
3 50%