title: How do I sum multiple "IF" statements without "Sumifs"
body: <p>I have to put together a weekly reporting system in Excel. I need to report on the month to dale sales results and the completed week (Fri-Thu). This is collected from multiple sales agents in sales documents stored in Sharepoint.</p>
  
  <p>For this, I've used "SUMIFS" to collect the data, the following way:</p>
  
  <pre><code>=SUMIFS('SHAREPOINTREF/FILE.xlsm'!SalesResults[One off],'SHAREPOINTREF/FILE.xlsm'!SalesResults[Date],"&gt;="&amp;B7,'SHAREPOINTREF/FILE.xlsm'!SalesResults[Date],"&lt;="&amp;C7)
  </code></pre>
  
  <p>(B7 is a cell reference which determines the start date of the week, with C7 being the end of the week)</p>
  
  <p>The trouble with SUMIFS, as well as SUMIF, COUNTBLANK, COUNTIF and COUNTIFS, is that they don't work when the sourcing document is closed. Microsoft has a workaround here: <a href="https://support.microsoft.com/kb/260415?wa=wsignin1.0" rel="nofollow">https://support.microsoft.com/kb/260415?wa=wsignin1.0</a></p>
  
  <p>I can't seem to figure out how to adapt the workaround methodology recommended to apply not just to a simple IF statement, but to multiples. I assume I would need to use an "AND" statement, but I keep getting errors when I'm trying.</p>
  
  <p>I have about half a dozen different calculations to make, but I am pretty confident if I can solve this one, the others should start to gel a bit better.</p>