ok which Sum... formula to use

[Lost]

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

 

[Lost]

thanx, works great. I got one more for ya. How do i eliminate double lots
being pulled over from column A to column C so i get this?
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

And not....
A B c
d
123456789 300 123456789 600
1234567890 1000 1234567890 3000

0 1508430
324
0 123456789
600
123456789 300 1234567890 3000
1234567890 1000 1508430 324
0
0
1508430 324
1234567890 1000

 

[Lost]

hmmm.....
It appears that since i use a formula to pul these numbers from another
sheet the filter option isnt working