In Cell D1 put this formula and drag it down

=SUMIF(A$1:A$10,$C1,B$1:B$10)


On Jan 28, 10:57*am, Lost wrote:
Help please....
Ok I need to figure out how to get column A to condense to column C and the
totals from Column B to sum up in column D. Column A&B is 66 cells long.
Sorry if this is to vauge, if need more info post.

* * * * A * * * * * * * * * * * * B * * * * * * * * * * * * * * * c * * * * * * * *
* * * * * *d
123456789 * * * 300 * * * * * * * * * * * 123456789 * * * * * * * * *600 *
1234567890 * * *1000 * * * * * * * * * * 1234567890 * * * * * * * * 3000 * * * *
0 * * * * * * * * * * * * * * * * * * * * * * * * * 1508430 * * * * * * * * * * *324
0 * * * *
123456789 * * * 300
1234567890 * * *1000 * *
0 * * * *
0 * * * *
1508430 * * * * * * * * 324
1234567890 * * *1000