Google Sheets: compare 2 column on different sheets and sum

Hi all,

I am working on an app build with Glide and attempting to create a clock-in and clock-out timesheet. However, I am having trouble with a formula.

I want to sum the total duration of hours (sheet 2, column E) based on the job name in (sheet 1, Column A). The formula should do the following:

1- Compare column A on sheet 1 with column A on sheet 2
2- If the text in any row on sheet 1 column A, matches the text in sheet 2 column A
3- Sum the corresponding row values in sheet 2 column E

the formula I am currently using is:
=sumif(Timesheet!A:A, Project!A:A,Timesheet!E:E)

This formula works appropriately, however... I want to add ArrayFormula to the beginning which does not work with SumIf.

I believe I need to use an If, Then statement, however, am not sure how to write that.

Any help would be appreciated.

Thank you!