Sum or Sumif?

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.

You can just use the Sumif without "Match"...

Like:

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Sum range = Range you want to Sum
Criteria Range = Range that you want to filter the first Criteira
Criteria = Filter

Gatti thank you very much for the solution! It was so simple..

No problems =)
Add reputation if possible.

Thanks for the reply

The first thing who did after testing the formula was the rep my friend..