Sum country exposure

[mpouliot8168]

I have a bunch of data the columns of concern are the account name, Country, % of Assets. There are several occurances of each account name (rows).

What I would like to do is sum all of the % of assets for each country per account.

My final output should look like this...
------------------Country1----------Country2
Account Name 1 % Total----------% Total

Account Name 2

I know this can be done with a pivot table but I would like to use a equation.

Thanks in advance

 

[T. Valko]

I have a bunch of data the columns of concern are the account name, Country, % of Assets. There are several occurances of each account name (rows).

What I would like to do is sum all of the % of assets for each country per account.

My final output should look like this...
------------------Country1----------Country2
Account Name 1 % Total----------% Total

Account Name 2

I know this can be done with a pivot table but I would like to use a equation.

Thanks in advance

What version of Excel are you using?

 

[Aladin Akyurek]

I have a bunch of data the columns of concern are the account name, Country, % of Assets. There are several occurances of each account name (rows).

What I would like to do is sum all of the % of assets for each country per account.

My final output should look like this...
------------------Country1----------Country2
Account Name 1 % Total----------% Total

Account Name 2

I know this can be done with a pivot table but I would like to use a equation.

Thanks in advance

Are we summing percentages?

On Excel 2007 or later...

B2, copied across and down:

=SUMIFS(Sheet1!$C$2:$C$400,Sheet1!$A$2:$A$400,$A2,Sheet1!$B$2:$B$400,B$1)

On all versions...

=SUMPRODUCT(Sheet1!$C$2:$C$400,--(Sheet1!$A$2:$A$400=$A2),--(Sheet1!$B$2:$B$400=B$1))

As can be seen from the formulas, Sheet1!A2:C400 is supposed to house the source data.