Please see attached file...
I would like a formula that sums the "amount" of each bucket type.
The Quantity of items under each bucket change often and the arrangement of Buckets change as well.
Example 1
US
10 entries
Mexico
5 entries
Canada
7 entries
Example 2
Canada
12 entries
US
4 entries
Mexico
20 entries
ect
I hope this makes sense.
Thanks
test.xlsx
Bookmarks