Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get the average mean of more than 30 numbers? | Excel Discussion (Misc queries) | |||
Average of top 3 numbers. | Excel Worksheet Functions | |||
average of kth largest numbers in an array of n numbers | Excel Worksheet Functions | |||
Average of Numbers in Top 5 | Excel Discussion (Misc queries) | |||
Average of numbers in column between to other numbers | Excel Discussion (Misc queries) |