I have an excel document that shows Partners, Regions and investment assets among other data.
Column B has a list of 100 partners, they come from 6 different regions and those regions are in column C : AB,BC,SK,MB,ON,ATL. Column D has the partners asset size listed.
I need to create a formula in a pivot table that can add all the regions together for their total asset size
So each region has a cell and in the adjacent cell would be the total assets.
Thank you
Bookmarks