Calculating a Dynamic Range

[andrewc]

Hi,

I would like to create a formula to calculate the linked growth rates (columns B & C) of two products between two dates.

The start and end dates are shown in F2:F3 and the formula to calculate the linked growth rates is in F6:G6. Values will be included in the calculation if their associated date in column A is greater than the start date and less than or equal to the end date.

I would like to amend the formula in F6 so that it takes into account both the start and end dates in F2:F3 and also the product name in F5.

Can someone please suggest a solution.

Thanks very much!