Circular Reference Error

[The Narcissist]

Hi All,

I've been breaking my head over the last 2 days but somehow can't get to the
root of this. I'm working on a leave management solution for my office and it
has 3 worksheets. The first one has the leave application data; the second
has the monthwise breakup of available and approved leave slots while the
third sheet has the accrued leave for each employee.

The solution allows the employees to enter the start date and end date for
their leaves and then approves the leave based on two conditions - there
should be enough slots available in that month and there should be a positive
accrued leave balance for the employee.

I'm using SUMPRODUCT to determine whether a leave can be approved or not.
However, the function is giving me a circular reference error.

Since the file is a bit too complex for me to explain here, I've uploaded
one with dummy data here.
http://myfreefilehosting.com/f/9da4f3afe1_1.03MB

I would be really grateful if someone could look at this and help me out.
The error is occuring on the first sheet (Application Data) in the column L.

Thanks,

Sam

 

[The Narcissist]

Hi All,

I enabled Iteration and it worked for me.

Thanks

Sam