Excel2007 Sheet link

[mikeconstantino]

OK, here is what I am tring to do. I have a workbook with two sheets in it. I am trying to set the second sheet up as a summary sheet and the first sheet up as an itemized sheet. Is there a way I can have the two sheets be linked together? All of the items on the itemized sheets have catagory numbers (300,301 etc) and a total costs. I want the second sheet to list the total of each catagoryfrom the first sheet.

 

[SydneyGeek]

Say the categories are in column A and the values are in column B of sheet1.

Place your category list in column A of sheet 2.
Assuming that the first categort is in A2, put this in B2:
=SUMIF(Sheet1!$A:$A,A2,Sheet1!$B:$B)

Fill down

Denis