How can i convert sumifs to sumproduct

this is my best guess based on what you wrote above, '=sumproduct(('\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$A:$A='\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$A$6)*('\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$C:$C='\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$C$247);'\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$E:$E)
it works without the referenced sheets in my test workbook.

And my guess is based on this working... =SUMPRODUCT((A:A=A6)*(C:C=C247),E:E)

I was trying my best to copy your referenced locations and I could have made a mistake as there is no way for me to test it.
That is why I pasted my test version in the post too. The test version worked... =SUMPRODUCT((A:A=A6)*(C:C=C247),E:E)
I would say to try to base your formula with the referenced workbooks based on the design of that formula.

ok, open your reference file(s) and your results workbook (where the formula will be) then in an empty cell (as a test) take the =sumproduct((then point to the section where you are referencing column A:A and reference =$A$6, then close parens) and add the asterisk * then open parens( and your next referenced location which looked like col C:C and add the =$C$247 and close parens) then semicolon and referenced location E:E and close parens again)
this is what I think it should look like without the outside references... =SUMPRODUCT((TOTAL'!$A:$A=TOTAL'!$A$6)*(TOTAL'!$C:$C=TOTAL'!$C$247);TOTAL'!$E:$E)

I tried it again, not sure if I made a transposition error the first time but this is what I got trying the whole thing again.
=SUMPRODUCT(('\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$A:$A='\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$A$6)*('\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$C:$C='\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$C$247);'\\metusrv\GUNCEL DOKUMANLAR\TimeSheet\[TimeSheet_2019_CANERGULER.xlsx]TOTAL'!$E:$E)
NOW, I'm not 100% sure it will work on closed spreadsheets either, I rarely use external workbooks and most people use some form of indirect when referencing a closed workbook.