=C1+INDIRECT("Sheet2!"&CHAR(ROW()+67)&1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"L. Howard Kittle" wrote in message
...
Hello Excel users and Experts,

=C1+INDIRECT(CHAR(ROW()+67)&1)

With this formula in B1 and pulled down will add C1 & D1, C2 & E1, C3 & F1
etc.

How can I make INDIRECT(CHAR(ROW()+67)&1) reference sheet 2 with C1, C2,
C3
on sheet 1?

So it sums C1 of sheet 1 and D1 of sheet 2
C2 of sheet 1 and E1 of sheet 2
and so on.

Thanks for any ideas.

Regards,
Howard