How to sum between two dates
 

I have my accounts in excel in the form of

Date ! Description ! Debit ! Credit

How do i sum all my debits and credits on another worksheet for a
particular date or between two specified dates ? Pls help.

Regards,
Ajit


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=560151

How to sum between two dates
 

To find all the dates between certain dates you can use auto filter, if
this is a basic table. Just go to auto filter and click it, then use
the drop down boxes to go to 'custom' then enter at least at most etc
and it should show you those dates.

There are more complex ways but its up to u how much u need?


--
mozza820
------------------------------------------------------------------------
mozza820's Profile: http://www.excelforum.com/member.php...o&userid=36226
View this thread: http://www.excelforum.com/showthread...hreadid=560151

How to sum between two dates
 

See attachment for solution. Solution
=+SUMIF($A$2:$A$15,"="&A20,$D2:$D15)-SUMIF($A$2:$A$15,""&B20,$D2:$D15)


+-------------------------------------------------------------------+
|Filename: Date Range Sumif.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5007 |
+-------------------------------------------------------------------+

--
blissworks
------------------------------------------------------------------------
blissworks's Profile: http://www.excelforum.com/member.php...o&userid=36156
View this thread: http://www.excelforum.com/showthread...hreadid=560151

How to sum between two dates
 

WOW ! Thanks a ton.

One more thing, pls.

I have a form to input all my accounts data. Can i have a form where i
input more than 1 record at a time, say type in 5 records and then hit
the update button ?


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=560151