Need Running Total

I'm addressing this issue after someone else originally designed this sheet.
I've made some changes, but I've added a "YEARLY OT Total" column to the 'PP' sheet, instead of using the original third sheet entitled, "Totals."

On the sheet entitled "PP," I need to have the "Yearly OT Total" (Column E) to keep a running total for each user, taken from "PP OT Total" (Column D).

For my usual tasks, I've been able to always use formulas, but for this running totals problem, this may need to be written with VB.
Unfortunately, I do not know VB (sad, but true).

OoooOOooo.... close, so close (quite brilliant, by the way)... thank you.

E3 needs to carry a running total of D3.

The formula gave the 'hours worked' total, so I modified it to multiply 'hours worked' by B3 (hours x rate).
I changed the formula to add such... =SUMPRODUCT(F3:AI3,--($F$1:$AI$1<>"")*B3)
... but when we add a new Pay Period, the field changed back to zero.

We need something to keep the total (E3) from pay period to pay period until we decide to 'zero' the balance.