How do I set up a running balance worksheet ?

[Guest]

I am trying to set up a worksheet where i put data into one cell and it is
added to the balance using only one cell continously. How can i do this and
have a running total daily and weekly/

 

[Guest]

So you want the users to enter this data in just one cell all the time? Does
that mean that each time the user opens the worksheet and enters the data
that they will then immediately close and save the workbook?

If that is your requirement you should be able to come up with a solution
using macros. You will have to test thoroughly all the different events
(open, close, change, etc) to ensure it works the way you want.

Another way may be to use the addin "I forgot what it's called" Excel
database tracking or something to that effect. However, in that case the
"running sum" would be stored in a separate workbook.

Hope that helps a little.

 

[Sandy Mann]

It is not clear from your post exactly what is is you are trying to do. If
you want to enter amounts down a column, say Column G, with dates in the
adjacent Column F then:

Running Total:
=SUM(G2:G800)

Total Today:
=SUMIF(F2:F800,TODAY(),G2:G800)

Total this week - assuming that for you the week starts on Sunday:
=SUMPRODUCT((TODAY()>=F2:F800-WEEKDAY(F2:F800)+1)*(TODAY()<=(F2:F800-WEEKDAY(F2:F800))+7)*(G2:G800))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk