How to sum comparing two lists and return differences?

Hi All,

I have two lists which need to compare the total units in each package to ensure those packages have the correct total units. If the total units in each package is tally, then it will return to "Match", if not, will turn to "Not Match"

Thank you!

Hello Sir,
Thank you for ur response

U will see in the total package of two data lists as belows:
Data 1:
Package 1 = 3
Package 2 = 4
Package 3 = 7
Package 4 = 4
Package 5 = 7

Data 2:
Package 1 = 4
Package 2 = 4
Package 3 = 7
Package 4 = 5
Package 5 = 9

So only package 2 & 3 have the same units, then these two package return to "Match" while the rest of package return to "Not Match" as got difference total unit in each package.

Try this,

E4
=IF(SUMIF([Package],[@Package],[Unit])=SUMIF(Table2[Package],[@Package],Table2[Unit]),"Match","Not Match")

copied down.

Hello Sir,

Thank you for your response. However, the formula seems to be error if I put the total unit of each product code.
Pls see the attached which I highlighted in yellow color as the total qty is correct, but still showing "Not Match".Attachment 836324

It works perfectly.
Thank you!

Here is the data Sir.