SumIf Problem
in the Summary table
=SUMIF(Data!A:A,A2,Data!B:B)
then
=SUMIF(Data!A:A,A2,Data!C:C)
etc.
assuming that the data is on a worksheet called Data
--
HTH
RP
(remove nothere from the email address if mailing direct)
"carl" wrote in message
...
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.
|