Print question

[Bob]

When I enter data into excel each time the number of
cells used is diffent. I would like a formula that will
put the total 2 or 3 cells below the last entry inputed.
How can I do this?

 

[Gord Dibben]

Bob

Formulas can only return values to the cells in which they are entered.

VBA Event code is probably what you need..

See David McRitchie's pages on Event procedures.

http://www.mvps.org/dmcritchie/excel/event.htm

Gord Dibben Excel MVP