(Was wrong question for problem though!) Multi-Criteria Multiplication

Hi,

I'm hoping someone can help me with the following.

I have three reference cells (a1, a2, a3).

Below, starting from b4 to l4 I have years from 2005 to 2015, row 5 for the same range contains data, row 6 (c to l) contains a growth rate.

I need to come up with a formula that can multiply (x * y * z *... [product-like formula]) the growth rates for all the years where the current year (row 4) is bigger than reference the reference year in a1 or smaller than reference year in a2. A3 is then used to multiply that total.

Any help that you may be able to give is greatly appreciated.

Thanks!