title: excel index/match with merged cell
body: <p><a href="https://i.stack.imgur.com/Pa93N.jpg" rel="nofollow noreferrer">Master Table</a></p>
  
  <p>How should I set the formula to get the figures with multiple criteria in merged cell?
  E.g. refer to the Master table, if I would like to know how many orders that Peter has made in Area 2 in Jan. I tried to use index match function, but didn't work out. 
  The criteria should go through > select "order" in column A > "Area 1" in column B > "Peter" in Column C > to have the row number, and match "2017/Jan" in column D.
  Can anyone suggest a formula to me? </p>