Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SumIf Problem
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem office assistant | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions |