How to merge two Tables and Add the amount at the same time

0 votes

I have two Excel tables containing the frequency of each product and its unique identification. Although Table A contains every product identifier we currently have, Table B has much fewer, therefore the order is not precisely the same. Can a formula add the amounts for me, or at the least, write the values from table B into the relevant rows of table A?

Example:

Table A

A 10

B 10

C 10

D 10

E 10

Table B

A 10

C 10

E 10

Expected Result

A 20

B 10

C 20

D 10

E 20
Jan 7 in Others by Kithuzzz
• 28,900 points
49 views

1 answer to this question.

0 votes

Use SUMPRODUCT like this:

 =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+SUMPRODUCT(($D$2:$D$4=A10)*$E$2:$E$4) 

enter image description here

answered Jan 7 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
0 answers

How is it possible for DynamoDB to support both Key-Value and Document database properties at the same time

As per DynamoDB's documentation, it supports both ...READ MORE

Apr 5, 2022 in Others by Kichu
• 19,050 points
270 views
0 votes
1 answer

How to use count and group by at the same select statement

This will do what you want (list of ...READ MORE

answered Nov 7, 2022 in Others by gaurav
• 22,960 points
89 views
0 votes
1 answer

VBA How to extract the date and time of arrival of a answered email

Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE

answered Jan 9 in Others by narikkadan
• 53,520 points
85 views
0 votes
1 answer

How to add Icon to the TextField in Flutter App?

Hi@akhtar, You can add any Icon to your ...READ MORE

answered Sep 3, 2020 in Others by MD
• 95,420 points
3,769 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
215 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
395 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
177 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,960 points
165 views
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 53,520 points
173 views
0 votes
1 answer

VBA How to extract the date and time of arrival of a answered email

Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE

answered Jan 9 in Others by narikkadan
• 53,520 points
42 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP