title: Conditional sum with merged cells using Sumiif()
body: <p>Scenario is 2 worksheets, Sheet1 and Sheet2.</p>
  
  <p>Sheet1 config:</p>
  
  <p><a href="https://i.stack.imgur.com/K752C.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K752C.png" alt="Sheet1"></a></p>
  
  <p>Sheet2 Config:</p>
  
  <p><a href="https://i.stack.imgur.com/17IIq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/17IIq.png" alt="Sheet2"></a></p>
  
  <p>The problem:
  The customer wants to input the daily amounts of bananas in Sheet2 (C:C) and have the totals automatically add in Sheet1 for the week number. The problem I'm facing with this, I believe is the merged cells. I was successful when I removed the merged cells and added the week number to all the cells with this formula    ( =SUMIF(A:A,E3,'Sheet2!C:C) ) But the customer would prefer to keep the merged cells, and with that it only returns the first value of that week. Am I missing something simple here? Can't seem to wrap my head around this. </p>