sumproduct with if conditions

hey

I went through this thread-
http://www.excelforum.com/excel-gene...criterias.html and it helped me solve part of my problem. The other part that remains unsolved is that I have this data spread across 3 sheets. SO I need to add an if condition to the sumproduct. The way it works is that if you see sheet quotation colums J29 to L29. J29 has a drop down list once we choose that the other drop down list is an indirect data validation formula . Once we select k29then we are asked to choose options in l29. once we choose the value must come automatically in cell N29 which has the formula from above. The problem is that the column J29 has 3 options the back up data of which is in 3 different sheets so can any one help solve this problem . Uploading file