N Net Golden Member Aug 30, 2003 1,592 2 81 Jan 6, 2009 #1 everytime i enter a number in column a i want column b to subtract 1 A 2 3 4 B 1 2 3 =SUM(A2:A4000) - 1 // will only subtract 1 once.
everytime i enter a number in column a i want column b to subtract 1 A 2 3 4 B 1 2 3 =SUM(A2:A4000) - 1 // will only subtract 1 once.
IronWing No Lifer Jul 20, 2001 71,965 32,150 136 Jan 6, 2009 #2 B1 =A1-1 B2 =A2-1 B3 =A3-1 . . . Bn = SUM(B1:B(n-1))