Percent of dollars per account, per issuer, copied down

**mattmuphy** · 04-24-2012, 01:39 PM

Hello,

I need help with a set of data - I attached a worksheet with the formula I am trying to build.

I have multiple 'issuers' that each have different $ amounts. These $ amounts are in a few different accounts and I need the concentration % in dollar amounts per issuer, per account.

Thanks for your help! Quick turnaround needed...

Best,

MattExcelHelp.xlsx

**Søren Larsen** · 04-24-2012, 01:44 PM

Something like this in D2 and copied down:

=B2/SUMIF($C$2:$C$19,C2,B2:B19) ?

**mattmuphy** · 04-24-2012, 01:48 PM

Originally Posted by Søren Larsen

Something like this in D2 and copied down:

=B2/SUMIF($C$2:$C$19,C2,B2:B19) ?

Unfortunately I need something that brings in column A as well, so that if Tom has more than 1 amount in Account A, it reflects that in column D as one percentage.

**Søren Larsen** · 04-24-2012, 01:59 PM

How about:

=SUMIFS($B$2:$B$19,$A$2:$A$19,A2,$C$2:$C$19,C2)/SUMIF($C$2:$C$19,C2,$B$2:$B$19)

It will give you duplicate values, though, when name and account # is the same.