Excel: Product Ifs?
<p>I have time series returns, and I want to get the product based on date range.
<code>=product(if($B:$B,A:A,"&gt;="&amp;$A$2,A:A,"&lt;="&amp;A13))</code> would not work because there are too many arguments for this function. Here is an example,</p>

<pre><code>12/31/2014    100.30%
01/31/2015    100.72%
02/28/2015    102.00%
03/31/2015    101.04%
04/30/2015    99.79%
05/31/2015    101.04%
06/30/2015    99.46%
07/31/2015    100.71%
08/31/2015    97.05%
09/30/2015    96.21%
10/31/2015    101.88%
11/30/2015    100.21%
12/31/2015    99.68%
01/31/2016    98.06%
02/29/2016    97.74%
03/31/2016    100.83%
</code></pre>

<p>I want to get the product of the returns from 2015. In this case, it is 99.62%.  Please help.</p>