LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing Data Ruth Excel Worksheet Functions 3 October 21st 09 08:56 AM
Summing like data (2) nba Excel Discussion (Misc queries) 2 October 2nd 09 03:57 AM
Summing up Data Tom K[_2_] Excel Worksheet Functions 10 January 16th 09 02:57 AM
summing data david72 Excel Discussion (Misc queries) 1 May 17th 06 04:15 AM
Summing data yesac142 Excel Discussion (Misc queries) 6 June 20th 05 01:47 PM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"