How to sum between two dates

[Newtonboy]

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
particular date or between two specified dates ? Pls help.

Regards,
Aji

 

[mozza820]

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

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

 

[blissworks]

See attachment for solution. Solutio
=+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
+-------------------------------------------------------------------

 

[Newtonboy]

WOW ! Thanks a ton.

One more thing, pls.

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