=(B1*100000)/C1
put that in the cell you want the total. then select it, go to the bottom right corner and drag down. it'll change the cell references for you.
If your data start in the second row, just make them B2, C2.
Last edited by flipped cracka; Apr 27, 2012 at 09:31 AM.