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