The result should only be one price and these are whole week prices (no broken numbers). The formula to the criteria: 24 weeks, MTSLI, General English, Start date 01/03/2010 should produce EUR 5740,00.

I'm struggling with combining "date" functionality and summing a variable number of periods (some products may only have two "price date ranges" or non at all (ie same price for the year).

Any help in how to structure this is much, much appreciated.