Thread: Summing Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rfhorn rfhorn is offline
external usenet poster
 
Posts: 4
Default Summing Data

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.