Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an Excel Worksheet includes travel costs by employee by type of
expense. These expense is allocate to cost centers based on the time each employee spends in the cost center. The worksheet lay out is: Col A Col B Col C Col E Col F Col G Col H Col I Employee Type of Exp Total exp 10-510 10-550 50-510 81-510 90-550 John Doe 5523 $500 $250 $50 $100 $0 $100 John Doe 5524 $250 $125 $25 $ 50 $0 $ 50 Mary Doe 5524 $100 $ 50 $50 Jack Doe 5523 $900 $250 $100 $250 $100 $200 Jack Doe 5524 $900 $250 $100 $250 $100 $200 Jane Doe 5523 $750 $500 $ 50 $ 50 $0 $150 The worksheet continues with some 100 employees and 8 different type of expenses that they coud incurr. What I would like to do is sum by cost center (i.e. 10-510, 10-550, 50-510, etc.) and tpye of expense (i.e. 5523, 5524, 5525, etc). What functions do I use? Do I have to have use several sumif statements? Any help would be greately appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing Data | Excel Worksheet Functions | |||
Summing like data (2) | Excel Discussion (Misc queries) | |||
Summing up Data | Excel Worksheet Functions | |||
summing data | Excel Discussion (Misc queries) | |||
Summing data | Excel Discussion (Misc queries) |