Total Numbers Bewteen Date Range

  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"><html><head><meta http-equiv="Content-Language" content="en-us"><title>SUMMING NUMBERS BETWEEN DATE RANGES.</title><meta name="description" content="SUMMING NUMBERS BETWEEN DATE RANGES."><meta name="keywords" content="SUMMING NUMBERS BETWEEN DATE RANGES."><link rel="STYLESHEET" href="http://www.ozgrid.com/css/ozgrid.css" type="text/css"><script type="text/javascript" src="http://www.ozgrid.com/SideNavJS/stmenu.js"></script>
    </head><body><a name="top"></a><h1>SUMMING NUMBERS BETWEEN DATE RANGES.</h1><h2>SUMMING NUMBERS BETWEEN DATE RANGES. See also: <a href="count-between-dates.htm">Count between date ranges</a></h2><p class="j">Let's take this a step further and sum up numbers in Column &quot;B&quot; that correspond to our date range.<br><br><b>=SUMPRODUCT(($A$1:$A$20&gt;DATE(2010,7,29))*($A$1:$A$20&lt;DATE(2010,8,1))*($B$1:$B$20))</b><br><br>We can even add another condition to numbers in Column B. Say we only want to sum numbers, in range B1:20, that are greater than 3. We would use;<br><br><b>=SUMPRODUCT(($A$1:$A$20&gt;DATE(2010,7,29))*($A$1:$A$20&lt;DATE(2010,8,1))*($B$1:$B$20&gt;3)*($B$1:$B$20))</b><br><br></p></body></html>