Fix Excel AVERAGE Returning a Sum Instead of an Average
Question details
The user needs to calculate the average of two nonadjacent cells instead of their sum.

- 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.
Check that H76 and H78 contain the values you want to average. Select the formula cell to inspect its contents in the formula bar.
Pass the cells to Excel AVERAGE as separate arguments
Use this formula to average H76 and H78 without adding them first.
Click the cell containing =AVERAGE(H76+H78), then click the formula bar.
Enter =AVERAGE(H76,H78) in the formula bar, using a comma to separate the two cell references.
Press Enter. Excel calculates the average of the numeric values in H76 and H78.

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. Open the workbook: Launch WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Select a result cell: Click the cell where you want the average to appear.
- 3. Enter the formula: Type =AVERAGE(H76,H78), replacing the references with your own cells if needed.
- 4. Calculate and save: Press Enter to calculate the result, then use File > Save to save the workbook.

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.




