From: Rashmi on 29 Apr 2010 02:34 I have data in a sheet with names and amounts due. Like A 500 B 300 A 600 B 300 C 400 C 200 There is a second sheet named summary. I want the totals of each person to appear in the summary sheet. These should be linked cells and any change in data in sheet 1 should be updtaed automatically From: ozgrid.com on 29 Apr 2010 02:40 Create a PivotTable http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Dave Hawley www.ozgrid.com "Rashmi" wrote in message news:56DC0F3A-8D60-4FE2-B778-3A07790EFE8A(a)microsoft.com...>I have data in a sheet with names and amounts due. Like > > A 500 > B 300 > A 600 > B 300 > C 400 > C 200 > > There is a second sheet named summary. I want the totals of each person to > appear in the summary sheet. These should be linked cells and any change > in > data in sheet 1 should be updtaed automatically From: Jacob Skaria on 29 Apr 2010 02:46 Hi Rashmi If you are looking for formulas; with data in sheet1 ColA/B and with the unique list of names in Sheet2 ColA; try the below formula.. With name in Sheet2 cell A1; try the below formula in cell B1 =SUMIF(Sheet1!A:A,A1,Sheet1!B:B) -- Jacob (MVP - Excel) "Rashmi" wrote: > I have data in a sheet with names and amounts due. Like > > A 500 > B 300 > A 600 > B 300 > C 400 > C 200 > > There is a second sheet named summary. I want the totals of each person to > appear in the summary sheet. These should be linked cells and any change in > data in sheet 1 should be updtaed automatically From: Eduardo on 29 Apr 2010 07:54 Hi, Let's say that in the summary sheet your names are in column A starting in row 2, and the data is in a sheet called data, names in column A and amounts in column B, so in column B of the summary enter =sumproduct(--(A2=Data!\$A\$2:\$A\$10000),data!\$B\$2:\$B\$10000) "Rashmi" wrote: > I have data in a sheet with names and amounts due. Like > > A 500 > B 300 > A 600 > B 300 > C 400 > C 200 > > There is a second sheet named summary. I want the totals of each person to > appear in the summary sheet. These should be linked cells and any change in > data in sheet 1 should be updtaed automatically  |  Pages: 1 Prev: Adding Fractions and Displaying as a percentage.Next: Advanced Data Filter