Add 2 values that's criteria match.

[Trevor Kaltenbrunn]

<ytd-expander id="expander" class="style-scope ytd-comment-renderer" style="display: block; --ytd-expander-collapsed-height:80px;"><yt-formatted-string id="content-text" slot="content" split-lines="" class="style-scope ytd-comment-renderer" style="white-space: pre-wrap; --yt-endpoint-visited-color:var(--yt-spec-icon-active-button-link); color: var(--ytd-comment-text-color); font-size: 1.4rem; line-height: 2rem;">Please can you help?

I have a sheet with both Inventory and Purchases on it, i want to calculate stock when entering a new purchase. That is when i enter a new item and i purchased 10 more it updates the Inventory.My inventory list (Item Code) is in Column A( 3 to 24) and the Quantity is in B (3 to 24)I have created a drop down menu in the Purchase column for the item code. I now need to enter a value in the purchase quantity column G3 (3 to 24) and this should add that value to the Quantity in column B.
I have added a link so that you can see the file.
https://www.dropbox.com/s/hqb16odpqn817d7/Inventory.xlsx?dl=0

</yt-formatted-string>
</ytd-expander><ytd-comment-action-buttons-renderer id="action-buttons" poll-status="null" class="style-scope ytd-comment-renderer" action-buttons-style="desktop-toolbar" style="display: block; color: var(--yt-spec-text-secondary); min-height: 16px; margin-top: 4px;">
<ytd-toggle-button-renderer id="like-button" class="style-scope ytd-comment-action-buttons-renderer style-text size-default" button-renderer="" is-icon-button="" has-no-text="" style="display: inline-block; text-transform: uppercase; --yt-button-icon-size:var(--ytd-comment-thumb-dimension); vertical-align: middle; font-size: 1.3rem; letter-spacing: 0.007px; color: var(--yt-spec-icon-inactive); margin-left: -8px;"><yt-icon-button id="button" class="style-scope ytd-toggle-button-renderer style-text size-default" aria-pressed="false" style="display: inline-block; position: relative; width: var(--yt-button-icon-size, var(--yt-icon-width, 40px)); height: var(--yt-button-icon-size, var(--yt-icon-height, 40px)); box-sizing: border-box; font-size: 0px; padding: var(--yt-button-icon-padding, 8px); color: var(--yt-button-color, inherit); line-height: 1; background-color: transparent; text-transform: inherit;"><button id="button" class="style-scope yt-icon-button" aria-label="like this comment along with 0 other people" style="vertical-align: middle; outline: none; background-image: none; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; margin: 0px; border-width: initial; border-style: none; border-color: initial; padding: 0px; width: 16px; height: 16px; line-height: 0; cursor: pointer; -webkit-tap-highlight-color: transparent;"><yt-icon class="style-scope ytd-toggle-button-renderer" style="display: inline-flex; align-items: center; justify-content: center; position: relative; vertical-align: middle; fill: var(--iron-icon-fill-color, currentcolor); stroke: none; margin-left: var(--iron-icon_-_margin-left); margin-bottom: var(--iron-icon_-_margin-bottom); margin-right: var(--iron-icon_-_margin-right); width: var(--yt-icon-button-icon-width, 100%); height: var(--yt-icon-button-icon-height, 100%);"><svg viewBox="0 0 24 24" preserveAspectRatio="xMidYMid meet" focusable="false" class="style-scope yt-icon" style="pointer-events: none; display: block; width: 100%; height: 100%;"><g class="style-scope yt-icon">
</path></g></svg></yt-icon></button></yt-icon-button></ytd-toggle-button-renderer><ytd-toggle-button-renderer id="dislike-button" class="style-scope ytd-comment-action-buttons-renderer style-text size-default" button-renderer="" is-icon-button="" has-no-text="" style="display: inline-block; text-transform: uppercase; --yt-button-icon-size:var(--ytd-comment-thumb-dimension); vertical-align: middle; font-size: 1.3rem; letter-spacing: 0.007px; color: var(--yt-spec-icon-inactive);"><yt-icon-button id="button" class="style-scope ytd-toggle-button-renderer style-text size-default" aria-pressed="false" style="display: inline-block; position: relative; width: var(--yt-button-icon-size, var(--yt-icon-width, 40px)); height: var(--yt-button-icon-size, var(--yt-icon-height, 40px)); box-sizing: border-box; font-size: 0px; padding: var(--yt-button-icon-padding, 8px); color: var(--yt-button-color, inherit); line-height: 1; background-color: transparent; text-transform: inherit;"><button id="button" class="style-scope yt-icon-button" aria-label="Dislike this comment" style="vertical-align: middle; outline: none; background-image: none; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; margin: 0px; border-width: initial; border-style: none; border-color: initial; padding: 0px; width: 16px; height: 16px; line-height: 0; cursor: pointer; -webkit-tap-highlight-color: transparent;"><yt-icon class="style-scope ytd-toggle-button-renderer" style="display: inline-flex; align-items: center; justify-content: center; position: relative; vertical-align: middle; fill: var(--iron-icon-fill-color, currentcolor); stroke: none; margin-left: var(--iron-icon_-_margin-left); margin-bottom: var(--iron-icon_-_margin-bottom); margin-right: var(--iron-icon_-_margin-right); width: var(--yt-icon-button-icon-width, 100%); height: var(--yt-icon-button-icon-height, 100%);"><svg viewBox="0 0 24 24" preserveAspectRatio="xMidYMid meet" focusable="false" class="style-scope yt-icon" style="pointer-events: none; display: block; width: 100%; height: 100%;"><g class="style-scope yt-icon">
</path></g></svg></yt-icon></button></yt-icon-button></ytd-toggle-button-renderer>
<ytd-button-renderer button-renderer="" class="style-scope ytd-comment-action-buttons-renderer style-text size-default" is-paper-button="" style="--yt-button-padding:8px 16px; vertical-align: middle; white-space: nowrap; font-size: 1.3rem; letter-spacing: 0.007px; text-transform: uppercase; display: inline-block; background-color: var(--yt-basic-background-color, ); color: var(--yt-spec-text-secondary); border-color: var(--yt-basic-foreground-title-color, var(--yt-spec-text-secondary)); border-radius: var(--yt-button-border-radius, 3px); margin: var(--yt-button-margin, 0 0.29em);">
<yt-formatted-string id="text" class="style-scope ytd-button-renderer style-text size-default" style="display: block; overflow: hidden; text-overflow: ellipsis;">REPLY</yt-formatted-string>

</paper-button></ytd-button-renderer>


</ytd-comment-action-buttons-renderer>
<ytd-menu-renderer class="style-scope ytd-comment-renderer" style="display: flex; flex-direction: row;"></ytd-menu-renderer>

 

[AlanY]

like this?

Book1
	A	B	C	D	E	F	G	H	I	J
1	Inventory					Purchases
2	Product ID	Quantity	Description	Selling Price	Grose Margin	Product ID	Quantity	Description	Date	Purchase Price
3	TK 001	20	3m Copper Pipe		25%	TK 001	10	3m Copper Pipe		R 255.00
4	TK 002	20	3M Gas Tubing		50%	TK 002	10	3M Gas Tubing		R 180.00
5	TK 003	10	90 Copper Connecter		50%	TK 003	10	90 Copper Connecter		R 2.50
6	TK 004	25	Strait Copper Conecter		10%	TK 004	10	Strait Copper Conecter		R 2.50
7	TK 005	10	Shut Off Valve		50%	TK 005	10	Shut Off Valve		R 129.00
8	TK 006	10	Tubing crimp		30%	TK 006	10	Tubing crimp		R 0.55
9						TK 001	10	3m Copper Pipe
10						TK 002	10	3M Gas Tubing
11						TK 004	15	Strait Copper Conecter
12
13
14
15
16
17
18
19
20
21
22
23
24
Inventory

Cell Formulas
Range	Formula
B3	=SUMIF($F$3:$F$24,A3,$G$3:$G$24)

 

[sooshil]

Hi Trevor Kaltenbrunn

Put this formula in cell B3, and pull it down.

=SUMIFS($G$3:G$24,F$3:F$24,A3)

Hope this helps.
Thanks.

 

[Trevor Kaltenbrunn]

Hi Trevor Kaltenbrunn

Put this formula in cell B3, and pull it down.

=SUMIFS($G$3:G$24,F$3:F$24,A3)

Hope this helps.
Thanks.

Thank you so much, that works great. I am very new at this so still learning.

 

[sooshil]

You are welcome.