Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
196
Views
Topic starter
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.
Posted : 09/06/2025 10:13 pm
Topic starter
Hi Riny,
Thanks for your help, and you are my excel doctor
Posted : 10/06/2025 1:45 pm
