There's actually a few ways to achieve this. So the easiest, assuming that
each row will only have a value in either column B or C, then simply use a
sum function in column D. If some rows have values in both column B and C,
then you may need to use an if statement in column D.

"Soth" wrote:

Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks