doing my head in here!...2 hrs later...all i want to do is key in a $ amount
down a cloumn and have it change the amount after i add the new amount so
that i dont have to go between calculator and key board...can someone
pleeeease help...im tearing my hair out here and the instructions in help are
vague and dont work!!...very very angry. thanks

If you're restricted to a single column, your best bet might be to simply put
a sum statement at the top of the column (e.g., sum(a1:a5000)) and freeze the
top row (i.e., highlight the second row in your worksheet, go to WINDOW -
FREEZE PANES). That will keep your sum statement where you can see it as you
add data to your worksheet.

If you can use a second column, it makes life much easier. Others may be
able to come up with more elegant solutions.

Good luck -

David

"frustrated" wrote:

doing my head in here!...2 hrs later...all i want to do is key in a $ amount
down a cloumn and have it change the amount after i add the new amount so
that i dont have to go between calculator and key board...can someone
pleeeease help...im tearing my hair out here and the instructions in help are
vague and dont work!!...very very angry. thanks