If the formula above is in A1 and your forumla is in B1, try...
=OFFSET($A$1,101*ROW()-1,0)

How to read this formula.

'OFFSET(A1' = Get the value in the cell that is offset from cell A1 by...

'101*ROW()' = 101 rows down times the row # that this forumla is on. ie. if
this formula is on row 1 multiply 101 * 1 to look at row 101, if on row 2,
multiply 101 * 2 to look at row 202, 303, 404, etc.

',0)' = Get the value in the cell that is offset from cell A1 by...
-0- columns from Column A.

HTH,
--
Gary Brown



"AccountantPB" wrote:

How do I reference the formula above and get the result off 101 rows below
that formula? I need to reference every 101 st row but put the information
one row on top of each other.

Thanks