Assumptions:

A1:E10 contains your data

First row contains your headers/labels

G2:G3 contain AccountA and AccountB

H1:K1 contain BrokerA, BrokerB, BrokerC, and BrokerD

Formula:

H2, copied across and down:

=SUMIF($A$2:$A$10,$G2,INDEX($B$2:$E$10,0,MATCH(H$1 ,$B$1:$E$1,0)))

Hope this helps!

In article ,
"carl" wrote:

I have a data table like this:

DataTable
AccountID BrokerA BrokerB BrokerC BrokerD
AccountA 0 0 27 0
AccountB 0 5 28 0
AccountB 177 1969 1749 400
AccountA 0 10 0 0
AccountB 5 60 0 0
AccountB 96 623 875 70
AccountA 0 10 7 0
AccountB 0 483 102 0
AccountB 70 180 358 33

I am trying to create this summary table:

SummaryTable
BrokerA BrokerB BrokerC BrokerD
AccountA 0 20 34 0
AccountB 348 3320 3112 503


Where the formula in the table body is looking at the Account a summing up
all values for each broker.

I thought I could do it with a formula.

Thank you in advance.