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

  • Thread starter Thread starter Coach J
  • Start date Start date
C

Coach J

I have columns with 100+ values. I need averages of the odd numbered rows
and then averages of the even numbered rows. Any ideas?
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Issue with "Average" showing in Status Bar 2
average if question 2
how to average row averages 3
Formulas: Averages 4
If average 3
average acts different in rows and columns? 6
how to average two different lines 1
pivot tables - totals different than the summarize function 1

Back
Top