How to Calculate Average if Greater Than Zero in Excel

To calculate the average of numbers greater than zero in Excel, you can use the AVERAGEIF function. AVERAGEIF calculates the average of cells that meet a given condition.

Here's how to use the AVERAGEIF function to calculate the average of numbers greater than zero:

1. Open your Excel workbook and locate the range of cells containing the numbers you want to calculate the average for.
2. Click on an empty cell where you want to display the average of numbers greater than zero.
3. Type the following formula:

=AVERAGEIF(range,">0")

Replace "range" with the actual range of cells containing the numbers. For example, if you want to calculate the average of numbers in cells A1 to A10, the formula would be:

=AVERAGEIF(A1:A10,">0")

4. Press Enter to calculate the average of numbers greater than zero. The result will be displayed in the selected cell.

Example

Let's say you have a list of numbers in cells A1 to A10, and you want to calculate the average of the numbers greater than zero.

1. Click on an empty cell, say B1, where you want to display the average of numbers greater than zero.
2. Type the following formula in cell B1:

=AVERAGEIF(A1:A10,">0")

3. Press Enter to calculate the average of numbers greater than zero.

The result will be displayed in cell B1. If the list of numbers in A1 to A10 changes, the average in B1 will update automatically.