Have you tried? Your description is confusing to me, but AVERAGE()
ignores blank cells and text...

In article ,
justamailman wrote:

can we use average in rows even two rows at the time when number are not in
consequent collums meaning there is some spaces between them without having
to add each number manually in the function window.