Hello,

Say I have a column that I want to work on with a formula. I want to take
each value from the column, apply the formula to it, and total the result
in a footer cell for the column. Example: subtract 3 and multiply by 1/2

1
2
3
4

will produce -1 + -1/2 + 0 + 1/2 = -1. I would like to do this without a
hidden column to hold the intermediate results of applying the function
to each cell - so this is NOT what I want:

1      -1
2    -0.5
3       0
4     0.5

and sum the intermediate column to find the answer. Is there a way to do
this? I'm using Excel 2002

Thanks,
Andrew