Autofill columns with rows?

I've got this function =COUNTIF(CALC!B$3:B$1500;C2) and when to copy down (autofill) I want to change to =COUNTIF(CALC!C$3:C$1500;C2) and then to =COUNTIF(CALC!D$3:D$1500;C2) etc. Is it possible?

Try

=COUNTIF(OFFSET(CALC!B$3:B$1500;0;ROWS(A$1:A1)-1);C$2)

Sure can!

Put this in place of your first formula and then copy downwards.

=COUNTIF(INDIRECT("CALC!"&CHAR(ROW(A2)+64)&"$3:"&CHAR(ROW(A2)+64)&"B$1500"),C$2)

Drat!

Bested by OFFSET's truncation again. That's twice in one week.