G Gord Dibben Apr 29, 2008 #2 In C1 enter =B1-A1 Copy that down column C as far as you wish. Wil. subtract single cell from single cell =SUM(B:B)-SUM(A:A) Will Subtract entire column from entire column. Without more detail I can't give much more. Gord Dibben MS Excel MVP
In C1 enter =B1-A1 Copy that down column C as far as you wish. Wil. subtract single cell from single cell =SUM(B:B)-SUM(A:A) Will Subtract entire column from entire column. Without more detail I can't give much more. Gord Dibben MS Excel MVP