D David Biddulph Jan 26, 2008 #2 If in column B you want the total from column A, then in whichever cell you want the result in column B, put the formula =SUM(A:A)
If in column B you want the total from column A, then in whichever cell you want the result in column B, put the formula =SUM(A:A)