row reference

M

Mike

I want to take the average of every other row in my data set and I will be
adding weeks to the data as time moves forward. Is there a relative or
absolute formula that does this?

Thanks for any help.
 
L

Luke M

Similar to columns, but pre-2007 can handle entire column callouts.

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

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

Both are array formulas, must be confirmed using Ctrl+Shift+Enter, not just
Enter.
 

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

column reference 1
maintain absolute reference when inserting rows 3
Change relative to absolute references in a block of cells 3
Copying with transpose and VB code 1
average if question 2
HLOOKUP - Relative cell reference in row index number 0
Copy formula 2
How to make columns absolute 2

Top