running total by date (not sorted by date though...)

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
>
>

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Is something I need to look into access to accomplish?