I currently have 2 different tables. One has a list of customers and their locations, and the other has a list of customers and how much product they ordered over the year. Not all customers made orders throughout the year. How can I match up the customers with how much they ordered?

Thanks!

The functions COUNTIF() and SUMIF() will most likely be what you need to use.