software

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: www.excelforum.com/member.php...foamp;userid=9431
View this thread: www.excelforum.com/showthread...hreadid=542183You may use the following array formula:
=SUM($C$1:$C$4*($B$1:$B$4lt;$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.

quot;rainxkingquot; wrote:

gt;
gt; Is it possible to have a running total go by date while not sorted by
gt; date?
gt; I would like to change the date but not change the sorting so that the
gt; running total of units is accurate at that period in time. SO basically
gt; I can see how many units I have at anygiven time. I hope this makes
gt; sense. I am sure someone has had to do this before...
gt;
gt; Below are two example tables.
gt;
gt;
gt; Example (sorted by Account):
gt; Acct---Date------units-runnning total
gt; A-----5/01/2006---10-----25
gt; B-----4/01/2006---10-----0
gt; C-----4/15/2006---15-----10
gt; D-----5/15/2006---20-----35
gt; Final Count----55
gt;
gt; Example (sorted by Date):
gt; Acct---Date------units-runnning total
gt; A-----4/01/2006---10-----0
gt; B-----4/15/2006---15-----10
gt; C-----5/01/2006---10-----25
gt; D-----5/15/2006---20-----35
gt; Final Count----55
gt;
gt; Thank you!!!
gt;
gt;
gt; --
gt; rainxking
gt; ------------------------------------------------------------------------
gt; rainxking's Profile: www.excelforum.com/member.php...foamp;userid=9431
gt; View this thread: www.excelforum.com/showthread...hreadid=542183
gt;
gt;

This seems to work
IN B1 enter =SUMPRODUCT(--($B$1:$B$10lt;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

quot;rainxkingquot; gt; wrote
in message ...
gt;
gt; Is it possible to have a running total go by date while not sorted by
gt; date?
gt; I would like to change the date but not change the sorting so that the
gt; running total of units is accurate at that period in time. SO basically
gt; I can see how many units I have at anygiven time. I hope this makes
gt; sense. I am sure someone has had to do this before...
gt;
gt; Below are two example tables.
gt;
gt;
gt; Example (sorted by Account):
gt; Acct---Date------units-runnning total
gt; A-----5/01/2006---10-----25
gt; B-----4/01/2006---10-----0
gt; C-----4/15/2006---15-----10
gt; D-----5/15/2006---20-----35
gt; Final Count----55
gt;
gt; Example (sorted by Date):
gt; Acct---Date------units-runnning total
gt; A-----4/01/2006---10-----0
gt; B-----4/15/2006---15-----10
gt; C-----5/01/2006---10-----25
gt; D-----5/15/2006---20-----35
gt; Final Count----55
gt;
gt; Thank you!!!
gt;
gt;
gt; --
gt; rainxking
gt; ------------------------------------------------------------------------
gt; rainxking's Profile:
gt; www.excelforum.com/member.php...foamp;userid=9431
gt; View this thread: www.excelforum.com/showthread...hreadid=542183
gt;

I think I maynot have explained this clearly... Here us a better example
what I have and what I am trying to do... I have units leaving and and
coming in. I need a way to allocate. Going by the table below... I want
to be able to change Joe's ShipDate to 6/25 and see how it affects the
OnHand Units. This way I can look at everything, change a few ship
dates and be able to accomidate more customers. Make Sense? Thanks
again for all the help... If I can get this working it will save me
hours and hours of work.RepShipDateQtyOnHand
Joe6/9/06-11281200
Matt6/9/06-37272
Jim6/15/06-150-300
John6/15/06-6-450
Sam6/15/06-12-456
DELIVERY6/15/064210-468
Adam6/25/06-2884678
Joe6/25/06-8974390
---------------------------------
Total 6/25/06 3493--
rainxking
------------------------------------------------------------------------
rainxking's Profile: www.excelforum.com/member.php...foamp;userid=9431
View this thread: www.excelforum.com/showthread...hreadid=542183
Is something I need to look into access to accomplish?--
rainxking
------------------------------------------------------------------------
rainxking's Profile: www.excelforum.com/member.php...foamp;userid=9431
View this thread: www.excelforum.com/showthread...hreadid=542183