Sum of a product with a date range

[hofst038]

I am trying to get a sum of something (devices installed) that is in a specific date range.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Devices Installed[/TD]
[/TR]
[TR]
[TD]3/1/2016[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3/12/2016[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3/15/2016[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3/17/2016[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4/3/2016[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 174"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Basically I want a sum of all devices that were installed based off of the date range of 3/12/2016-3/19/2016. Does someone have a good formula to use for this?

 

[gaz_chops]

Look at sumifs

 

[hofst038]

I tried that, Im stuck on this Formula: =SUMIFS($A$2:$A$6, ">=" &DATEVALUE("3/7/2016"), "<="&DATEVALUE("3/14/2016"),$B$2:$B$6)

 

[gaz_chops]

Try

=SUMIFS($B$2:$B$6,$A$2:$A$6, ">=" &"3/7/2016", $A$2:$A$6,"<="&"3/14/2016")

 

[hofst038]

Success. Thanks!

 

[gaz_chops]

You're welcome.