Referance colum in formula by number instead of letter

[rpaulson]

current
=COUNTIF(F:F,">1")

need
=COUNTIF(6,">1")

thanks for looking

Ross

 

[FormR]

Hi, you could try:

=COUNTIF(INDEX($A:$ZZ,0,6),">1")

 

[Rick Rothstein]

Here is one way...

=COUNTIF(OFFSET(A1,0,6-1,1000),">1")

Note that we are offsetting 5 columns from column A, so we have to subtract 1 from your 6 in order for you to put 6 into the formula (which I assume will ultimately come from a cell reference).

EDIT NOTE: I like FormR's solution better than this one (his formula is non-volatile whereas mine isn't).

 

[rpaulson]

Txs guys, works perfect