Change Column Reference When Formula is Dragged Down

[billbilliamson]

How can I change the Column reference as a formula is dragged down?

For example,

Sumif(sheet1!A:A,

When I drag down the formula, I want it to change to be:

Sumif(sheet1!B:B,

Is it some kind of Indirect or Offset formula?

Thanks!

 

[njimack]

INDIRECT("Sheet1!"&CHAR(64+ROW(A1))&":"&CHAR(64+ROW(A1)))

 

[billbilliamson]

How would this work if the Sumif is:

Sumif(Sheet1!CY:CY

And i want it to change to:

Sumif(Sheet1!CZ:CZ

Will the "CHAR" formula still work?