sum if-match quantity

Stacy Rueda

Board Regular
Hi guys,

I have this excel file that I don't know how to start or what to use function or necessarily for macro.

I have input sheet, like below: When I input No. and quantity then it will sum to another sheet that match to the column that I inputted.

So, once I input No. 1-A, then quantity to other column will become 150, or if negative -50, then it will become 50.

 INPUT DATA No. 1-A QTY. 50

<colgroup><col><col></colgroup><tbody>
</tbody>

 No QTY 1-A 100 Quantity will become 150 2-B 89 3-C 100 4-D 100 5-E 100 6-F 102 7-G 10 8-H 1092 9-I 1082 10-J 192 11-K 1982 12-L 1762

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

Hope you guys can help me. Thank you in advance.

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

so what u want???

Hi @aqeelnokia99, I want to create macro (but don't know how to start) that will compute automatically Quantity when I input quantity from other sheet. Once I input No. 1-A, then quantity to other column will become 150, or if negative -50, then it will become 50.

INPUT DATA SHEET
No. QTY.
1-A 50

RESULT:

 No QTY 1-A 100 Quantity will become 150 2-B 89 3-C 100

<tbody>
</tbody>

if u put A1 in qty table its add 50 +??? or its become 150 for all and waht about 2-b and 3-c ? i can make a formula not macro

Hi @aqeelnokia99, it will add depends on the quantity I input on "Input data sheet", and for 2-b, 3-c, 4-d rows, it will add also based from the quantity I entered.

if its based on qty u want if u enter 100 in qty its become 150 if u eneter 50 its add 100 and become 150 if u add 30 its add 120 and become 150 ???

no thanks.. I'm running out of explanation, sorry.

Replies
14
Views
357
Replies
5
Views
226
Replies
4
Views
246
Replies
1
Views
147
Replies
6
Views
380

1,203,514
Messages
6,055,840
Members
444,828
Latest member
StaffordStag

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back