How Do I average rows?

It will let me average columns but not rows, can I average rows? For example I am trying to average e4 through n4, but instead of getting the average it only gives me ###. The formula I am uses in =average(e4,n4)

The formula seems ok; probably the other column is misformatted and unable to display the number. That is, the column with the row average probably is formatted to display a date or some text value.

On LO 4.4.2.2, Calc will average on row or column no problem.

(feel free to click the check (image description) to the left if the answer helps)

The column width may be too small for the size of the answer. Try widening the column or changing the format to reduce the number of decimals displayed.