Hi, using a formula to find some data from other sheet, 
=IFERROR(INDEX('Sheet1'!$S$1:$S$5000;MATCH(1;($I$6='Sheet1'!$J$1:$J$5000)*($H$9='Sheet1'!$G$1:$G$5000)*($G10='Sheet1'!$F$1:$F$5000);0));"")
I wonder if i can find the total based on the criteria of the formula
=IFERROR(SUM('Sheet1'!$S$1:$S$5000;MATCH(1;($I$6='Sheet1'!$J$1:$J$5000)*($H$9='Sheet1'!$G$1:$G$5000)*($G10='Sheet1'!$F$1:$F$5000);0));"")
or
=IFERROR(SUMIF('Sheet1'!$S$1:$S$5000;MATCH(1;($I$6='Sheet1'!$J$1:$J$5000)*($H$9='Sheet1'!$G$1:$G$5000)*($G10='Sheet1'!$F$1:$F$5000);0));"")
Thanks in advance.