average a row of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Insert a column and enter =AVERAGE(B1:IV1)

Copy down 50 rows.


Gord Dibben MS Excel MVP
 
| >> 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"??
 
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.
 
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?
 
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)
 
Back
Top