This attached Excel workbook contains a formula I use frequently to evaluate businesses that have multiple locations and a lot of data. The SUMIF(), INDEX() and MATCH() functions can be used together to dynamically call columns of information. The trick is to input a "0" in the INDEX() function for the value "row_num." This results in the function returning the entire column.