average a row of numbers?

wannabe68 · External Since: Aug 05, 2007 Posts: 9

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.

Gord Dibben · External Since: Feb 23, 2004 Posts: 8800

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
<wannabe68 DeleteThis @discussions.microsoft.com> 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.

wannabe68 · External Since: Aug 05, 2007 Posts: 9

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
> <wannabe68 RemoveThis @discussions.microsoft.com> 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.
>
>

JMB · External Since: Jun 08, 2005 Posts: 1029

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
> > <wannabe68 RemoveThis @discussions.microsoft.com> 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.
> >
> >

wannabe68 · External Since: Aug 05, 2007 Posts: 9

Thanks JBM, that answers that question. Nothing is easy.
If I have a spead sheet with 50 columns and 50 rows, what is the formula
that I should put in the "formula" line to get the average of each row, all
at one click of the ?. Is a formula going to give me what I want?

"JMB" wrote:

> 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
> > > <wannabe68.TakeThisOut@discussions.microsoft.com> 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.
> > >
> > >

JLatham · External Since: Sep 19, 2006 Posts: 1511

Look at the formula that Gord Dibben provided:
If your rows go from column A through AX, and start at row 1 and continue on
down for 50 rows, then in AY1:
=AVERAGE(A1:AX1)
and copy down the sheet.

If there are numbers all the way from row 1 to row 50 in column AX, you can
move the mousepointer to the lower right corner of AY1 until it becomes a
small cross (or thick plus sign - depends on how you think of it) and
double-click the left mouse button and the formula will fill to the last
number automatically.

Note that AVERAGE() ignores empty cells. In other words, if you have the
value 5 in A1, C1 and G1 and all other cells between them are empty,
=AVERAGE(A1:G1) will give you 5 (15/3)
But if you need to include the total possible count, then you could use
=SUM(A1:G1)/columns(A:G) which will give you 2.142857 (15/7)

"wannabe68" wrote:

> Thanks JBM, that answers that question. Nothing is easy.
> If I have a spead sheet with 50 columns and 50 rows, what is the formula
> that I should put in the "formula" line to get the average of each row, all
> at one click of the ?. Is a formula going to give me what I want?
>
> "JMB" wrote:
>
> > 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
> > > > <wannabe68.RemoveThis@discussions.microsoft.com> 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.
> > > >
> > > >