performance calc

[Kolacube]

Please can someone help me wiith the below as it needs to consider 3 variables, type, start date and end date:


Variable fields

Type: X1

Start date: 02/02/2008

End Date: 30/04/2009

Based on Type selected I need To Calculate performance
as follows:

if start date is less than 15th of month then performance for start month is ignored or zero otherwise performance is month performance +
the sum of each months performance to end date if end date is leass than 15 then do not include for that month.


ie above would be
29 Feb =0 + 31 March =0.6 + 30 Apr =1.6

so answer would be 2.2


Performance table

Type x1 x2 x3
month
30 Sept 2007 3.5 4.51 21.9
31 October 2007 3.9 4.91 18.9
30 November 2007 0.1 -2.19 8.6
31 December 2007 1.3 -0.09 11.3
31 January 2008 0.8 -2.29 12.1
29 February 2008 2.4 2.21 15.9
31 March 2008 0.6 -1.29 10.2
30 April 2008 1.6 0.01 12.4
31 May 2008 1.3 0.41 11.4
30 June 2008 -0.7 -2.49 6.9

Thanks

[hifliers]

Attach A Sample File

Vishnu

[JBeaucaire]

Please Login or Register  to view this content.

Here's one way. I added Named Ranges to your chart to allow an INDIRECT() formula to locate the data.