IF function: how to auto count values?

[Schalk]

Is ther any way to do this:

=IF('[PERFORMANCE SHEETS.xlsx]G1'!Q$38=1,1," ")

when I drag the cell ACROSS to the right, the values must add 1:

=IF('[PERFORMANCE SHEETS.xlsx]G1'!Q$38=1,1," ")
becomes
=IF('[PERFORMANCE SHEETS.xlsx]G1'!Q$38=2,2," ")
becomes
=IF('[PERFORMANCE SHEETS.xlsx]G1'!Q$38=3,3," ")

and so on?

[zbor]

Try:

=IF('[PERFORMANCE SHEETS.xlsx]G1'!Q$38=COLUMNS($A$1:A$1),COLUMNS($A$1:A$1)," ")

Also, do you need space at the end? Usually it's easier to use excel data WITHOUT space:

=IF('[PERFORMANCE SHEETS.xlsx]G1'!Q$38=COLUMNS($A$1:A$1),COLUMNS($A$1:A$1), "")

[Schalk]

Thanx! Going to try that!