Thread: Need a formula to average every other value in a column.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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?


Reply With QuoteReply With Quote