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.

If your two criteria is cost center and type, you can do some simple SUMIF
functions. Create a table similar to what you have now, with Cost Center
being your headers, and type being your row headers. I'll assume you've
created this on a new sheet, and your data is on "Data" sheet. In B2 of your
new sheet:
=SUMIF('Data'!$B:$B,$A2,'Data'!E:E)

Copy across and down as needed to fill your report table.

If you're looking for more data control/sorting capabilities, you might also
want to look into creating a PivotTable. They're very good for
organizing/summing data, and you can easily manipulate the layout.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rfhorn" wrote:

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.

I'm sorry Luke M but I don't understand the formula you offered. What is the
"data"!E:E part?




"Luke M" wrote:

If your two criteria is cost center and type, you can do some simple SUMIF
functions. Create a table similar to what you have now, with Cost Center
being your headers, and type being your row headers. I'll assume you've
created this on a new sheet, and your data is on "Data" sheet. In B2 of your
new sheet:
=SUMIF('Data'!$B:$B,$A2,'Data'!E:E)

Copy across and down as needed to fill your report table.

If you're looking for more data control/sorting capabilities, you might also
want to look into creating a PivotTable. They're very good for
organizing/summing data, and you can easily manipulate the layout.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rfhorn" wrote:

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.

Luke M, I got it to work. thanks for your help, I really appreciate it.


"Luke M" wrote:

If your two criteria is cost center and type, you can do some simple SUMIF
functions. Create a table similar to what you have now, with Cost Center
being your headers, and type being your row headers. I'll assume you've
created this on a new sheet, and your data is on "Data" sheet. In B2 of your
new sheet:
=SUMIF('Data'!$B:$B,$A2,'Data'!E:E)

Copy across and down as needed to fill your report table.

If you're looking for more data control/sorting capabilities, you might also
want to look into creating a PivotTable. They're very good for
organizing/summing data, and you can easily manipulate the layout.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rfhorn" wrote:

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.