As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Compute Averages for Specific Cells in Excel

If you're familiar with Microsoft Excel, you likely know how to find the average of a cell range. But what if you need to calculate the average for only specific cells? For instance, imagine having a range with both numbers and empty cells or text. This guide demonstrates how to compute the average for specific cells while ignoring empty or text-containing ones in Excel.

Method 1: Employing the AVERAGE Function

The AVERAGE function, categorized as a Statistical Function in Excel, serves as a versatile tool for calculating averages. While it excels at finding the average for a cell range, it does come with a limitation—it includes only cells with numbers and ignores empty or text-filled cells.

To use the AVERAGE function:

  1. Select the cell for the average.
  2. Enter =AVERAGE(
  3. Choose the cell range for averaging, and type )
  4. Press Enter.

Method 2: Employing the SUM Function

The SUM function, categorized as a Math/Trig Function in Excel, is a handy tool for summing cell ranges. Similar to the AVERAGE function, it has a limitation—it only considers cells with numbers, ignoring empty or text-filled cells.

To use the SUM function:

  1. Select the cell for the sum.
  2. Enter =SUM(
  3. Choose the cell range for summing, and type )
  4. Press Enter.