I have updated the order quantity and arrival quantity in the same sheet. However, I need to calculate the summary arrival quantity based on the BOE numbers in column A (A5). The arrival quantities are listed in column L (L5:L10) with extra characters added to the BOE numbers (e.g., "A123" instead of just "A").

I would like to know if there is a formula that can help me update the summary arrival quantities in column E (E5:E7) based on the BOE numbers in column N (N5:N10).

Could you please assist me with this? I would greatly appreciate it.