=AVERAGE(A2:Axxxxx) in A1
AVERAGE function ignores blank cells and/or text
What is in the "blank" cells that causes your average to be incorrect?
=IF(ISNUMBER(AD3),F3-ROUND(AC3+0.5,0),"")
Or, at the bottom of my spreadsheet, nothing at all.
I have #VALUE! displayed in G2 where I entered =AVERAGE(G3:G122)
I see G52 also displays #VALUE! There's something bad in that row,
but there are lots of complex items there. That may be what I need
to replace (with space for now?)
If you do have zeros(not shown) then in A1 place this array formula.
=AVERAGE(IF(A2:Axxxx>0,A2:Axxxx))
Array formulas are entered with CTRL + SHIFT + ENTER
--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."
- James Madison