This seems to work
IN B1 enter =SUMPRODUCT(--($B$1:$B$10<B1),$C$1:$C$10)
Copy down the column
change B10, and C10 to fit you needs
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rainxking" wrote
in message ...

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