averaging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fcs13 - 21 Feb 2007 21:55 GMT

excel 2003

have long lists of data entry (column one days, column two week average),
need to be able to drag down along column (B) rather than retype specific
cells to average, problem comes in when dragging it will average 2:3
procedding average 1:2

A B
1 average 1:2
2 average 3:4
3
4

sounds simple but I cant figure it out, would greatly appreciate any help.

Reply to this Message

Bernard Liengme - 21 Feb 2007 22:32 GMT

Use =AVERAGE(INDEX(A:A,ROW(A1)*2-1),INDEX(A:A,ROW(A1)*2))
and copy down the column
If you data spans, for example, A5:A100, replace A:A by A5:A100 but leave A1
alone in the formula
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> excel 2003
>
[quoted text clipped - 10 lines]
>
> sounds simple but I cant figure it out, would greatly appreciate any help.

Reply to this Message

fcs13 - 21 Feb 2007 23:24 GMT

minor detail, formula works great, right function, but i can't manipulate it
to average seven days from column a into column b then repeating, rather than
two
thanks for your time.

> Use =AVERAGE(INDEX(A:A,ROW(A1)*2-1),INDEX(A:A,ROW(A1)*2))
> and copy down the column
[quoted text clipped - 15 lines]
> >
> > sounds simple but I cant figure it out, would greatly appreciate any help.

Reply to this Message

Bernard Liengme - 22 Feb 2007 13:57 GMT

=AVERAGE(INDEX(A:A,ROW(A1)*7-6),INDEX(A:A,ROW(A1)*7))
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> minor detail, formula works great, right function, but i can't manipulate
> it
[quoted text clipped - 26 lines]
>> > sounds simple but I cant figure it out, would greatly appreciate any
>> > help.

Reply to this Message