sum total for a given period

[Muthukrishnan V]

Excel 2007
Sample sheet:
Col A Date (dd-mm-yyyy)
Col B Withdrawal (Amount - numerical)
Col C Deposit (Amount - numerical)
A3 02-07-2018
A4 02-07-2018
A5 04-07-2018
A6 04-07-2018
A7 06-07-2018
A8 09-07-2018
B3 11000
B4 15000
B5 0
B6 17000
B7 5000
B8 12000
C3 20000
C4 30000
C5 15000
C6 0
C7 18000
C8 10000
In F3 I enter a Start date in dd-mm-yyyy
In F4 I enter a End date in dd-mm-yyyy ( date >F3)
In F5 I want sum total of withdrawals for the period from F3 to F4.
I request a formula for F5 to show withdrawal amount, for the given period in F3 to F4.

 

[steve the fish]

Like this:

=SUMIFS(B3:B8,A3:A8,">="&F3,A3:A8,"<"&F4+1)