Running Total

Depending on how your data is setup you could probably use
SumProduct or Sumif.  Might be easier to have a column with
the month and date in it so you dont get months from
different years mixed up.

regards

Darryl.

-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Steven
Dji
Sent: Tuesday, 31 October 2006 3:53 PM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Running Total


I would like to sum a number of amounts based on the month,
Dear List,

I would like to sum a number of amounts based on the month,
if I fill in 6 (Jun) then it will sum the amount from Jan -
Jun. I have tried using nested IF but the conditions are
more than 7.
Thanks in advanced.

Rgds,
Steven



------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

This email and any attachments may contain privileged and
confidential information and are intended for the named
addressee only. If you have received this e-mail in error,
please notify the sender and delete this e-mail immediately.
Any confidentiality, privilege or copyright is not waived or
lost because this e-mail has been sent to you in error. It
is your responsibility to check this e-mail and any
attachments for viruses.  No warranty is made that this
material is free from computer virus or any other defect or
error.  Any loss/damage incurred by using this material is
not the sender's responsibility.  The sender's entire
liability will be limited to resupplying the material.

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G