I have an excel workbook with several sheets. On one sheet I have "details"
with a column identifying "cost centers". In another sheet I want to show the
sums of the different cost centers (a summary of the details). Is there a
function whereby I can have all the detailed items summed by cost center
identification number from the column in the details sheet reflect
automatically in the summary sheet? Maybe a simplified example:

detail sheet:
cc amt
100 5.00
100 6.00
101 1.00

summary sheet:
cc amt
100 11.00
101 1.00

Of course, the detail sheet has hundreds of cost centers and many more
individual entries. I just want some sort of conditional lookup that will
find and sum all like cost center entries.

have a look in the help index for SUMIF

--
Don Guillett
SalesAid Software

"Ray S." wrote in message
...
I have an excel workbook with several sheets. On one sheet I have
"details"
with a column identifying "cost centers". In another sheet I want to show
the
sums of the different cost centers (a summary of the details). Is there a
function whereby I can have all the detailed items summed by cost center
identification number from the column in the details sheet reflect
automatically in the summary sheet? Maybe a simplified example:

detail sheet:
cc amt
100 5.00
100 6.00
101 1.00

summary sheet:
cc amt
100 11.00
101 1.00

Of course, the detail sheet has hundreds of cost centers and many more
individual entries. I just want some sort of conditional lookup that will
find and sum all like cost center entries.

requires visual basic, maybe someone will write the code for you

"Ray S." wrote:

I have an excel workbook with several sheets. On one sheet I have "details"
with a column identifying "cost centers". In another sheet I want to show the
sums of the different cost centers (a summary of the details). Is there a
function whereby I can have all the detailed items summed by cost center
identification number from the column in the details sheet reflect
automatically in the summary sheet? Maybe a simplified example:

detail sheet:
cc amt
100 5.00
100 6.00
101 1.00

summary sheet:
cc amt
100 11.00
101 1.00

Of course, the detail sheet has hundreds of cost centers and many more
individual entries. I just want some sort of conditional lookup that will
find and sum all like cost center entries.

Check sumif. Ex: =sumif(Detail!A:A,A2,Detail!B:B). This would look for
matches of cell A2 in column A of the Detail sheet and, where found, sum up
the corresponding entries of column B of the Detail sheet. (I think of the
arguments to SUMIF as 'where to look, what to find, what to add up'). --Bruce

"Ray S." wrote:

I have an excel workbook with several sheets. On one sheet I have "details"
with a column identifying "cost centers". In another sheet I want to show the
sums of the different cost centers (a summary of the details). Is there a
function whereby I can have all the detailed items summed by cost center
identification number from the column in the details sheet reflect
automatically in the summary sheet? Maybe a simplified example:

detail sheet:
cc amt
100 5.00
100 6.00
101 1.00

summary sheet:
cc amt
100 11.00
101 1.00

Of course, the detail sheet has hundreds of cost centers and many more
individual entries. I just want some sort of conditional lookup that will
find and sum all like cost center entries.

Another option .. quite ideal to use a pivot table (PT)
(Takes only a few clicks n drags to set-up)

In the detail sheet, select any cell within the table

Click Data Pivot Table Report
Click Next Next
In step3 of the wiz.:
Drag and drop "cc" within the ROW area
Drag and drop "amt" within the DATA area
(It'll appear as "Sum of amt")
Click Finish

The PT will be created in a new sheet just to the left,
giving:

Sum of amt
cc Total
100 11
101 1
Grand Total 12

The PT would provide the summary you want
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ray S." wrote in message
...
I have an excel workbook with several sheets. On one sheet I have
"details"
with a column identifying "cost centers". In another sheet I want to show
the
sums of the different cost centers (a summary of the details). Is there a
function whereby I can have all the detailed items summed by cost center
identification number from the column in the details sheet reflect
automatically in the summary sheet? Maybe a simplified example:

detail sheet:
cc amt
100 5.00
100 6.00
101 1.00

summary sheet:
cc amt
100 11.00
101 1.00

Of course, the detail sheet has hundreds of cost centers and many more
individual entries. I just want some sort of conditional lookup that will
find and sum all like cost center entries.