Formula Errors

Fix Excel AVERAGE Returning a Sum Instead of an Average

Steve KSteve K Nov 13, 2026 869 views

Question details

The user needs to calculate the average of two nonadjacent cells instead of their sum.

Why Excel AVERAGE Returns a Sum Instead of an Average
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet formula uses AVERAGE to calculate a result from cells H76 and H78.
Observed behavior
The formula =AVERAGE(H76+H78) adds the cell values first, so AVERAGE receives one value and returns the sum.
Before you start

Check that H76 and H78 contain the values you want to average. Select the formula cell to inspect its contents in the formula bar.

Solution 1Recommended

Pass the cells to Excel AVERAGE as separate arguments

Use this formula to average H76 and H78 without adding them first.

1
Select the formula cell

Click the cell containing =AVERAGE(H76+H78), then click the formula bar.

2
Replace the plus sign

Enter =AVERAGE(H76,H78) in the formula bar, using a comma to separate the two cell references.

3
Calculate the average

Press Enter. Excel calculates the average of the numeric values in H76 and H78.

Pass the cells to Excel AVERAGE as separate arguments
Check your argument separator: If Excel uses semicolons as argument separators, enter =AVERAGE(H76;H78) instead. AVERAGE ignores empty referenced cells.
Calculate averages in WPS Spreadsheet

Average nonadjacent cells in WPS Spreadsheet

Open your workbook in WPS Spreadsheet and use AVERAGE with separate cell references to calculate the mean without adding the cells first.

  1. 1. Open the workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Select a result cell: Click the cell where you want the average to appear.
  3. 3. Enter the formula: Type =AVERAGE(H76,H78), replacing the references with your own cells if needed.
  4. 4. Calculate and save: Press Enter to calculate the result, then use File > Save to save the workbook.
Calculate averages across nonadjacent cellsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with formulas in a free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does =AVERAGE(H76+H78) return the sum?

Excel evaluates H76+H78 first. AVERAGE then receives only that single sum, so its result is the same value.

How do I average two nonadjacent cells in Excel?

Enter =AVERAGE(H76,H78) in a worksheet cell. Replace H76 and H78 with the cell references you need.

What if Excel does not accept the comma in my formula?

Your regional settings may require a semicolon. Try =AVERAGE(H76;H78) in the formula bar.

Does AVERAGE count an empty cell as zero?

No. AVERAGE ignores empty referenced cells, but it includes cells that contain the number zero.