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, 2023 in Others 363 views

## 1 answer to this question.

Use SUMPRODUCT like this:

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

• 63,720 points

## 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

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

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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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