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.

Date	Devices Installed
3/1/2016	2
3/12/2016	1
3/15/2016	2
3/17/2016	1
4/3/2016	1

<tbody>
</tbody>

<tbody>
</tbody>

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.