Well you don't tell us the formula and whetjer its odd or even rows so heres
a solution for even rows provided there is not text in the range

=SUMPRODUCT((MOD(ROW($A$1:$A$100),2)=0)*($A$1:$A$1 00))

Change the xero to 1 for odd rows.

If there is or could be text in the range use this instead
=SUM(IF(MOD(ROW($A$1:$A$100),2)=0,$A$1:$A$100,0))
This is an array so enter with CTRL+Shift+Enter.

Mike

"Neville Bailey" wrote:

I have created a formula to reference a cell in another workbook. I now want
to copy the formula down a number of consecutive rows, but I want it to
reference the cell in every second row in the other workbook.

How can I do that?