Based on this post: If you want to build dynamic dashboards in Excel that update automatically when you import new data, the SUMIF and SUMIFS functions are important to understand. The SUMIFS function especially works as a multi-criteria VLOOKUP.