You can use the combination of INDEX and MATCH to look up values in an array. But did you know that you can also use this combination in conjunction with the SUM function to total up rows or colums? Here’s how!
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.