Column total when Matching 1st Column

[nuclearsnake]

Say I have 3 columns..

344 2 10
344 4 20
344 5 25
555 1 2
555 1 2
555 2 4
555 5 6
666 6 60
666 4 40

And I want to perform a function that would leave me with the total when the items in the 1st column match...

IE:

344 11 45
555 9 14
666 10 100

How could I do that?
Something like "If col A1 = A2 then sum it and check if A2 = A3..." is what Im thinking
Note: I have 1300 Rows....

[BigBas]

the easiest wasy would probably be to go to data>subtotals>at each change in a>sum

[loumf]

If you don't want the subtotals interspersed with the data, you could use a pivot table. You need to give the columns headers. Then the first column would go in the row area, and the next two would go in the Data Area.

Here are detailed directions (for Excel 2003)

1. Choose Data->Pivot Table and and Pivot Chart Report from the main menu
2. Where is the Data? (Microsoft Office Excel List)
3. What kind of report? (Pivot Table)
4. Next
5. Where is the Data: Range? (Highlight the data including the header)
6. Next
7. Where do you want it (Choose what you want)
8. Finish
9. Drag the column A header to the Row Area
10. Drag the column B and C headers to the Data Area

It will automatically sum them and group them by the value in the first column. Another advantage is that it doesn't need to be sorted by the first column -- it will group them even if the matches are not right next to each other.