title: I need to ignore blank cells in an excel 2007 MIN array but I keep getting 0's
body: <p>Here is the array I have:  </p>
  
  <pre><code>{=MIN(IF('APRIL 2011'!E3:E999&lt;&gt;"",'APRIL 2011'!E3:E999  
   *('APRIL 2011'!E3:E999*('APRIL 2011'!D3:D999='APRIL TOTALS'!A2))))}  
  </code></pre>
  
  <p>It still returns zeroes with empty cells!</p>