how do i cumulatively add in a single column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need a formula to add up the sum of an employee 3
CUMULATIVE ADDING IN A COLUMN? 2
how do i calculate cumulative percentages in Pivot table reports 3
how do you total columns that are not adjacent 2
How to ignore a column of numbers in Grand Total for rows 1
How do i create a cumulative worksheet 1
How do I set a maximum amount in a cell? 2
cumulative total in pivot 1

Back
Top