Need a formula to average every other value in a column.
 

I have columns with 100+ values. I need averages of the odd numbered rows
and then averages of the even numbered rows. Any ideas?

Need a formula to average every other value in a column.
 

=AVERAGE(IF(MOD(A1:A100,2),A1:A100,"")) for the odd rows
=AVERAGE(IF(MOD(A1:A100,2),"",A1:A100)) for the even rows

In each case, enter as an array formula, with Control Shift Enter.
--
David Biddulph

"Coach J" <Coach wrote in message
...
I have columns with 100+ values. I need averages of the odd numbered rows
and then averages of the even numbered rows. Any ideas?

Need a formula to average every other value in a column.
 

for the even rows:

=AVERAGE(IF(MOD(A1:A100,2)=0,A1:A100)) as an array formula

for the odd rows:

=AVERAGE(IF(MOD(A1:A100,2)=1,A1:A100)) as an array formula
--
Gary''s Student - gsnu200775


"Coach J" wrote:

I have columns with 100+ values. I need averages of the odd numbered rows
and then averages of the even numbered rows. Any ideas?

Need a formula to average every other value in a column.
 

I'd use:

Odd Rows:
=AVERAGE(IF((ISNUMBER(A1:A100)*MOD(ROW(A1:A100),2) )=1,A1:A100))

Even Rows:
=AVERAGE(IF((ISNUMBER(A1:A100)*MOD(ROW(A1:A100),2) )=0,A1:A100))

Both array entered.

Coach J wrote:

I have columns with 100+ values. I need averages of the odd numbered rows
and then averages of the even numbered rows. Any ideas?

--

Dave Peterson