 <p>I have had issues once or twice with it not skipping blanks, particularly on reports that have blanks that aren't really blank.</p> <p>To be safe I use </p> <pre><code>{=AVERAGEIF(IF(ISNUMBER(F:F),A:A)} </code></pre>