Set Blanks To Zero Excel How To Find The

To hide zero values in cells, go to the Show in Workbook section, then clear the Zero values check box.

Use the AVERAGE function to find the mean in a range of data.

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

Excel has a few functions that calculate the central tendency in a range of data: AVERAGE, MEDIAN, and MODE.

The most commonly derived measure of central tendency is the simple average (mean).

It is calculated by adding a group of numbers and dividing the result by the count of those numbers.

Set Blanks To Zero Excel How To Find The

Heres how to find the arithmetic mean using the AVERAGE function in Excel.

Excel has a shortcut to enter the AVERAGE function, sometimes referred to as AutoAverage due to its association with the AutoSum feature, which is located on the Home tab of the ribbon.

The steps below cover how to enter the AVERAGE function, as shown in row four of the example image above, using the shortcut method.

Select cell D4, which is where the formula results will display.

Go to the Home tab and, in the Editing group, select the AutoSum drop-down arrow.

Select Average in the list to enter the AVERAGE function into cell D4.

Highlight cells A4 to C4 to enter these references as arguments for the function, then press the Enter key on the keyboard.

This result is the average of the three numbers ( 4, 20, and 6 ).

Follow these guidelines when entering data for the AVERAGE function.

It looks first for the number data above and then to the left.

When it comes to finding average values in Excel, theres a difference between blank or empty cells and those containing a zero value.

Blank cells are ignored by the AVERAGE function, which can be handy since it makes finding the average for non-contiguous cells of data easy.

Excel displays a zero in cells with a zero value by default, such as the result of calculations.

If this option is off, such cells are left blank but are included in average calculations.

To hide zero values in cells, go to the Display options for this worksheet section, then clear the Show a zero in cells that have zero value check box.

To display zero values in cells, select the Show a zero in cells that have zero value check box.

Select Preferences in the list to open the Preferences dialog box.

Set Blanks To Zero Excel For Mac