running total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

just another user - 20 Jan 2004 19:31 GMT

i am working on a worksheet that i want to have a running
total, the only problem is that i have one cell that will
a number and change to another number, i can't find a way
to capture the previous number. for example i have cell
a2 that is 20 next dave a2 = 10 for a total of 30 for cell
a2

Reply to this Message

Biff - 21 Jan 2004 02:51 GMT

Hi just,

Take a look at this link. This is what you want.

http://mcgimpsey.com/excel/accumulator.html

Biff

>-----Original Message-----
>i am working on a worksheet that i want to have a running
[quoted text clipped - 4 lines]
>a2
>.

Reply to this Message

- 21 Jan 2004 03:31 GMT

>-----Original Message-----
>i am working on a worksheet that i want to have a running
[quoted text clipped - 5 lines]
>.
>try using the $ sign in front of the number reference

(e.g. A$2

Reply to this Message