Thread: excel question

How can I get the average of every six values (rows) in a column?

Do you mean:
1 to 6
2 to 7
3 to 8

Then just enter this formula and copy down as needed:

=AVERAGE(A1:A6)

OR, do you mean:
1 to 6
7 to 12
13 to 18

Then just enter this formula and copy down as needed:

=AVERAGE(INDEX(A:A,6*ROW(A1)-5):INDEX(A:A,6*ROW(A1)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jt42" <jt42@discussions.microsoft.com> wrote in message
news:FB845F65-7C84-46FC-92CF-D599FE5B3064@microsoft.com...
> How can I get the average of every six values (rows) in a column?

Yes, I meant the latter:
1 to 6, 7 to 12, 13 to 18, etc.
I thought that perhaps there is a formula using bin of 6, but what you
suggested works very well.
Many thanks, Joanna

"Ragdyer" wrote:

> Do you mean:
> 1 to 6
> 2 to 7
> 3 to 8
>
> Then just enter this formula and copy down as needed:
>
> =AVERAGE(A1:A6)
>
> OR, do you mean:
> 1 to 6
> 7 to 12
> 13 to 18
>
> Then just enter this formula and copy down as needed:
>
> =AVERAGE(INDEX(A:A,6*ROW(A1)-5):INDEX(A:A,6*ROW(A1)))
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "jt42" <jt42@discussions.microsoft.com> wrote in message
> news:FB845F65-7C84-46FC-92CF-D599FE5B3064@microsoft.com...
> > How can I get the average of every six values (rows) in a column?
>
>

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jt42" <jt42@discussions.microsoft.com> wrote in message
news:3DEB4957-D7D1-43C0-A1A8-E56F791CB684@microsoft.com...
> Yes, I meant the latter:
> 1 to 6, 7 to 12, 13 to 18, etc.
> I thought that perhaps there is a formula using bin of 6, but what you
> suggested works very well.
> Many thanks, Joanna
>
> "Ragdyer" wrote:
>
> > Do you mean:
> > 1 to 6
> > 2 to 7
> > 3 to 8
> >
> > Then just enter this formula and copy down as needed:
> >
> > =AVERAGE(A1:A6)
> >
> > OR, do you mean:
> > 1 to 6
> > 7 to 12
> > 13 to 18
> >
> > Then just enter this formula and copy down as needed:
> >
> > =AVERAGE(INDEX(A:A,6*ROW(A1)-5):INDEX(A:A,6*ROW(A1)))
> >
> > --
> > HTH,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> > "jt42" <jt42@discussions.microsoft.com> wrote in message
> > news:FB845F65-7C84-46FC-92CF-D599FE5B3064@microsoft.com...
> > > How can I get the average of every six values (rows) in a column?
> >
> >