I am having trouble as I am trying to find the total sales for a region using VLOOKUP & INDEX+MATCH. But when using SUMIFS, I am getting the desired result. The sheet I am using is just a practice sheet as I am new to Excel. Kindly help me to resolve this issue.
18 KB Views: 6