Sumif - Date Range

[HelpfulMan]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]400[/TD]
[TD]13/3/15[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD]20/3/15[/TD]
[/TR]
[TR]
[TD]180[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]310[/TD]
[TD]29/4/15[/TD]
[/TR]
[TR]
[TD]750[/TD]
[TD]21/3/15[/TD]
[/TR]
[TR]
[TD]384[/TD]
[TD]15/3/15[/TD]
[/TR]
[TR]
[TD]900[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


The above is an example of my current problem. I'm trying to arrange for a SumIf formula to calculate the value of Column A within a specific date range (i.e. how many sales from A to be completed between the 13th-20th?). There will be some blank ones for incomplete sales.

Any help or formula building suggestions would be appreciated!

 

[sericom]

=sumifs(a1:a7,b1:b7,">=13/3/2015",b1:b7,"<=20/3/2015")