mercredi 26 septembre 2018

Sumif and IF, to add up one column and compare it to another column

I have two lists that I want to compare to see if they match, but in one list the numbers are broken down into individual lots so I need to sum them first to make sure they match the other list which only shows the total amount.

Here's an example:

5 ABC 18 ABC 6 ABC 7 ABC 1 CDE 8 CDE 5 CDE 2 CDE

So I want to make sure that the sum of the ABC and CDE on the left matches the total amount of ABC and CDE on the right. I can do this using multiple columns, but I am trying for a more...elegant way (one nested formula).

Aucun commentaire:

Enregistrer un commentaire