<div>
Hi,<br />
<br />
since the question does not exclude 0s<br />
<br />
then try
<pre><code id="code-20-41728820-1">=AVERAGEIF(D2:D12,&quot;&gt;=0&quot;,D2:D12)</code></pre>
Regards
</div>


Hi,

since the question does not exclude 0s

then try

=AVERAGEIF(D2:D12,">=0",D2:D12)

Regards

<div>
that part i got but what about getting the info from a different sheet for example data is in sheet1 but i am trying to display data in sheet2?
</div>


that part i got but what about getting the info from a different sheet for example data is in sheet1 but i am trying to display data in sheet2?

<div>
then try in sheet2<br />
<br />
=AVERAGEIF(Sheet1!D2:D12,&quot;<wbr />&gt;=0&quot;,Sheet<wbr />1!D2:D12)
</div>


then try in sheet2

=AVERAGEIF(Sheet1!D2:D12,">=0",Sheet1!D2:D12)

<div>
so it avoids any negative numbers?
</div>


<div>
i had to do this &quot;&gt;0&quot; since this &quot;&gt;=0 gave me wrong information
</div>


i had to do this ">0" since this ">=0 gave me wrong information

<div>
<div class="content wysiwyg-content">
trying to get the average number ignoring all negative value, data and is in one workbook and the info should be in another.
</div>
</div>


trying to get the average number ignoring all negative value, data and is in one workbook and the info should be in another.

Excel Formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.