Please help me obi-wan-kenobe with ms excel. your my only hope?

Question

totally simple for those of you who know excel...

i have two columns of numbers covering about 30 rows.
I want to calculate the average of each row. (so the mean of 2 numbers)
I could do this in my head but i need to know how to tell excel to do this.

The functions interface is confusing me
Thanks!

Answer 1

Since you have only 2 columns you can get the average of each row by deviding the addition of row figures by 2.

Eg. Say you have 10 in A1 and 20 in B1. Then the formula in C1 should be =(A1+B1)/2 i.e=(10+20)/2=15

and copy that formula to all 30 rows.

You can also use the average function.
=average(A1:B1)

Thats all

Answer 2

To find the average, in the cell you want the answer type
=average(A1, A2, A3)
or whatever the cell numbers are. This will the find the average of A1, A2 and A3. So in your case, you'll only need two numbers. You can also do this by typing
=average( and then clicking on a cell, typing a comma, and clicking on another.

If you want to a lot at once, type
=average(A1:A6)
for instance, and this will calculate the average of all the numbers between A1 and A6

You can copy and paste the formula from the first cell into all the others, and it will automatically change the numbers/letters to calculate the correct averages.

Answer 3

Say you have 10 numbers in row A1 to J1

You get the average by "summing' all the numbers and then dividing by the how many numbers you have

So the formula would be =Sum(A1:J1)/10

Answer 4

am not sure if this is what u mean...

=(sum of each row)/30

thats the average for each row