averaging months

PMRetired2012

Board Regular
Joined
Aug 6, 2019
Messages
60
What im trying to do is average a row of numbers that represent the months. what im getting back as a result is: when i put a IFERROR(AVERAGE(A1:A5),0) FORMULA for Cells A1 thru A5 and i want my answer in CELL A7 i get one answer of the number i put in cell A1 not the adverage of that number if i only have a number in A1.

If i go down to cells C1 thru C5 and want a adverage in Cell C6 using the same IFERROR formula of those cells and i put a number in C1 it will adverage the number using the all the cells (divive by 5) as in Cell C6 would have 5 if you used in cells C1 Thru all 5s. average of 25/5 = 5.

so my question is why wont the same formula work in all the cells the same. i have reasurched it alot and i have no clue. I have tried everthing.

Need Help !
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

offthelip

Well-known Member
Joined
Dec 23, 2017
Messages
1,157
Office Version
2010
Platform
Windows
try this:
Code:
= IFERROR(SUM(A1:A5)/COLUMNS(A1:A5),0)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,382
Messages
5,444,129
Members
405,269
Latest member
Kjtakke

This Week's Hot Topics

Top