You may use the following array formula:
=SUM($C$1:$C$4*($B$1:$B$4<$B1))
Change the ranges as appropiate (here B column are dates, and C column
units), and enter it with CRTL+SHIFT+ENTER

Hope this helps,
Miguel.

"rainxking" wrote:


Is it possible to have a running total go by date while not sorted by
date?
I would like to change the date but not change the sorting so that the
running total of units is accurate at that period in time. SO basically
I can see how many units I have at anygiven time. I hope this makes
sense. I am sure someone has had to do this before...

Below are two example tables.


Example (sorted by Account):
Acct---Date------units-runnning total
A-----5/01/2006---10-----25
B-----4/01/2006---10-----0
C-----4/15/2006---15-----10
D-----5/15/2006---20-----35
Final Count----55

Example (sorted by Date):
Acct---Date------units-runnning total
A-----4/01/2006---10-----0
B-----4/15/2006---15-----10
C-----5/01/2006---10-----25
D-----5/15/2006---20-----35
Final Count----55

Thank you!!!


--
rainxking
------------------------------------------------------------------------
rainxking's Profile: http://www.excelforum.com/member.php...fo&userid=9431
View this thread: http://www.excelforum.com/showthread...hreadid=542183