I have a spreadsheet that has a list something like this.... A B C D E 1 Rej. Amount 2 bot 23 3 top 54 4 sid 10 5 bot 24 6 bot 12 7 sid 10 8 9 10 The list is a lot longer and has a lot more items. What I am trying to do is on another sheet have one of each item and have a total by each one (example, sid - 20) so that I can pie chart them. I actually download this information from a data collection system and past it into excel, so every week everything in page one in excel would be erased and new data would be pasted. I would appreciate any help I can get. Thanks! It's not how smart you are, but knowing where to find the resorces.

Sorry about that the list got pushed together. I redid it. A B C D E 1 Rej. Amount 2 bot 23 3 top 54 4 sid 10 5 bot 24 6 bot 12 7 sid 10 8 9 10 It's not how smart you are, but knowing where to find the resorces.

Use the sumif formula. It will be something like =sumif(B:B,"sid",C:C)

Or, in addition to Grok's formula; select all the data in column A (including the label of "Rej"). Go to Data, Filter, Advanced Filter; copy to D1 and select Unique records. This will list all items but only once for each item listed. Then apply Grok's formula in E2 as: =SUMIF(A:A,D2,B:B) Hit Enter Click on E2 and now wave over the bottom right hand corner of E2 and DoubleClick on the black Cross to copy the formula down the column adjacent to Column D. Now select columns D and E, right click and select Copy, go to Sheet2 (or wherever), Right click on A1 and select Paste Special, Values. HTH Bryan