Forum

Notifications
Clear all

[Solved] BOE SUMIF SORMULA

4 Posts
2 Users
0 Reactions
91 Views
Md Saliha
(@navsal66)
Posts: 118
Estimable Member
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
Riny van Eekelen
(@riny)
Posts: 1246
Member Moderator
 

@navsal66

In E5:

=SUMIF($L$5:$L$10,A5&"?",$N$5:$N$10)

and copy down.

 
Posted : 09/06/2025 10:26 pm
Md Saliha
(@navsal66)
Posts: 118
Estimable Member
Topic starter
 

Hi Riny,

Thanks for your help, and you are my excel doctor

 
Posted : 10/06/2025 1:45 pm
Riny van Eekelen
(@riny)
Posts: 1246
Member Moderator
 

@navsal66 Glad I could help

 
Posted : 10/06/2025 2:38 pm
Share: