A few days ago I asked for a formula to auto-calculate a column for ATTRITION
as follows:
col A
row 1 10,000
row 2 8,000
row 3 6,000
row 4
row 5 __________
Attrition 4,000

The formula in cell [A6] is =A1-OFFSET(A1,COUNT(A1:A5)-1,0) confirmed with
Ctrl+Shift+Enter instead of just with Enter.

Now I need to put a simple SUM formula in cells [A1,A2,A3,A4,A5] that sum
columns B,C,D,E across, for example: cell [A1] would contain the formula
SUM(B1:E1), yet still have cell [A6] auto-calculate the same as before. When
I put formulas in cells [A1,A2,A3,A4,A5] the formula in cell [A6] doesn't
function anymore. Does anyone know how to make this work? Thanks