get sum of values based on assigned code

Hello forum members,

Based on the file that i have attached, on sheet3, column I (Quantity),
I want to have a formula that can add up add the the values in Sheet2 from the Stock out Qty ( Column N) based on the Code Number.

E.g., in sheet 3 cell I2, based on the code number 5004216(1)-MSG NO.015, it will look up for all the individual entries in Sheet 2 and sum the stock in qty for all those entries whose codes are also 5004216(1)-MSG NO.015.

Thus it should return me a value of 5292 at cell I2.

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Better - thanks.

As per code 5004216(1)-MSG NO.015 the result in I2 is 570.

in I2 simple sumif formula use.

Formula:

Please Login or Register  to view this content.