title: VBA - Summing Array column with conditions - Like excel sumif
body: <p>I would like to sum a <em>column</em> in an array based on several conditions.
  If the data were in Excel I would use a <code>=SUMIFS</code> formula.</p>
  
  <p>The sample dataset in a 2 dimensional array I have is:</p>
  
  <pre><code>ID1     ID2     ID3     Value
  0       1       1       4
  0       2       2       5
  1       3       2       6
  0       1       1       3
  0       1       0       2
  </code></pre>
  
  <p>I would like to sum the value column based on the following conditions:</p>
  
  <pre><code>ID1=0
  ID2=1
  ID3=1
  </code></pre>
  
  <p>Therefore rows 1 and 4 meet this criteria and hence the answer would be 7 (4+3)</p>
  
  <p>How Would I construct this in VBA.</p>
  
  <p>Note that the ID's may be infinite and they may be strings either so I <strong>can't</strong> set <code>ID=0</code> in the loop.</p>