The gray area in the bottom right of your spreadsheet. If your NumLock is
on, the status bar will say "NUM". If you don't see it, verify it is
activated by clicking View (there s/b a check next to status bar - click it
to activate it if there is no check).

But you will still need to select each row individually to get the average.
The formula will be much faster and will be easier to refer back to.


"wannabe68" wrote:

Gord
I was reading another post by George G. He wrote:
An easy way that doesn't use any formula.
| Right-click the Status Bar, and put a checkmark next to 'Average'.
| Highlight the cells you wish to average, the average of these cells
| will be displayed on the Status Bar!
That sounds like the easiest way to get what I want. My problem is, where
is the "Status Bar"??

"Gord Dibben" wrote:

Insert a column and enter =AVERAGE(B1:IV1)

Copy down 50 rows.


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 16:56:01 -0700, wannabe68
wrote:

I am trying to get the average of a row of numbers with various numbers of
columns. I have 50 rows of numbers and am looking for the formula to average
all of the rows, showing the average of each row. I know how to do them
individually, but very time consuming. Any help would be appeciated.