"Rick" skrev i en meddelelse
...
Hi, Leo,

I don't know why, the method only worked once for me. now every time i
tried after step 6, the '=SUM()' goes to the top cell and doen't do the
trick!?

.<

Hi again

You probably have one or more empty cells
at the start of the column.
If for instance your first data cell is A5, instead
of step 1 do this:

In the name box (at the extreme left of the formula bar)
enter A5:A10000 (10000 can be any number =
the address of the last cell in column A containinig data)
Finish with <Enter.

Continue with step 2 to 6.

Leo Heuser