What function can I use
 

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.

What function can I use
 

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.

What function can I use
 

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.

What function can I use
 

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.

What function can I use
 

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.