Statement reconciliation not pulling in bank interest

My first time reconciling statements End balance from satement is listed as an error and it is off by my bank interest amount

Associated with error message:


Not sure why a #REF! would appear, but I know in the past I’ve forgotten to add my interest to my “Deposits/Payments” which has thrown my match off by the total of the interest. My bank breaks interest out into a separate line, so just adding what they consider “Deposits/Payments” isn’t enough, have to do a little math in my head, or use a formula in the cell to add them together.

That worked thank you