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.