Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 20
Default average a row of numbers?

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.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default average a row of numbers?

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.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 20
Default average a row of numbers?

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.



  #4   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default average a row of numbers?

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.



  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 20
Default average a row of numbers?

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
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.




  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default average a row of numbers?

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
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i get the average mean of more than 30 numbers? GV Excel Discussion (Misc queries) 1 September 29th 06 04:45 PM
Average of top 3 numbers. Belzbub Excel Worksheet Functions 26 November 29th 05 12:45 AM
average of kth largest numbers in an array of n numbers georgeb Excel Worksheet Functions 6 September 5th 05 05:57 AM
Average of Numbers in Top 5 Jake Excel Discussion (Misc queries) 7 April 28th 05 09:46 PM
Average of numbers in column between to other numbers Ditandhischeese Excel Discussion (Misc queries) 2 March 31st 05 03:35 AM


All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"