Averages in Excel

aardvaak

I have Excel 2002, and I am recording my pedameter readings from Sunday through to Saturday. and then down the page week 1,2,3 etc.

Can someone please advise me how I can get an average number of steps at the end of the week.

zombiecazz

Sum each week and divide by 7
e.g.formula is =SUM(G2:G8)/7
you would replace G2:G8 with the cells that hold your Sunday to Saturday figures.

Chippy_Minton

Use the AVERAGE worksheet function. For example:

=AVERAGE(B2:H2)

in cell I2 averages the week 1 readings (assuming row 1 is used for column headings).

aardvaak

Would you please tell me how to sum the week?

zombiecazz

type in =Sum(cell containing day one reading : cell containing day 7 reading)

eg if your Sunday reading is in cell B2 and the rest of the readings are directly below the your formula would be =Sum (B2:B8)

aardvaak

I am sorry if this sounds a stupid question.

I have enter my figures Sun-Sat in boxes A1-A7 then clicked on box A8 and put the above formula in - nothing happens - do I have to click on something else to get the answer.

BLACKHURSTM

aardvaak wrote:

I am sorry if this sounds a stupid question.

I have enter my figures Sun-Sat in boxes A1-A7 then clicked on box A8 and put the above formula in - nothing happens - do I have to click on something else to get the answer.

Replace the B2 and B8 in the formulae with A1 and A7

zombiecazz Was working on the assumption you have placed the week days in colum A and the values in colum B.And also had colum headings ib A1 and B1
And in B8 put the formulae =AVERAGE(B2:H2)

In basic terms the formulae =AVERAGE(B2:H2) is adding up all the values in cells B2 to H2 (B2,B3,B4,B5,B6,B7 and B8 and devide by the amount of values in this exaple devide by 7.

aardvaak

BLACKHURSTM wrote:

change the "above sum" to eg if your Sunday reading is in cell a1 and the rest of the readings are directly below the your formula would be =Sum (A1:A7)
Therefore the formulae in cell a8 will be =AVERAGE(A1:A7)

I have done the above and to make sure it is right I cut and paste your formula in A8 and the formula just stays there - is there something else I should click on?

espresso

aardvaak wrote:

I have done the above and to make sure it is right I cut and paste your formula in A8 and the formula just stays there - is there something else I should click on?

:doh:

How about pressing Enter

:rolleyes:

csarge

Best way to do it is to click into cell you want the average in.
Type in "=AVERAGE("
Don't press enter or use quotes, but keep the bracket!

Then click and hold left button on the first entry you want the average of, and and drag the mouse to the last entry(keep holding button)....you should see the box change as you drag it. Once you've got them all, let button go and hit enter.


edit(s): doh

BLACKHURSTM

Check your emails I have sent you a spreedsheet with 2 worksheets.One with your spreedsheet and one with zombiecazz assumption.zombiecazz is the normal way you would expect you to lay out the data you wanted to analyse.