#### blackcat

##### New Member

Can you help me out on this question please?

I'm trying to drag a formula horizontally where only the worksheet reference should change dynamically, while the rest stays locked.

Example here:

=COUNTIF('9FTD'!A:A,A2)

=COUNTIF('10FTD'!A:A,A2)

=COUNTIF('11FTD'!A:A,A2)

Worksheet names are 9FTD, 10FTD and 11FTD.

When I drag the formula horizontally. I would like to tweak this formula =COUNTIF('9FTD'!A:A,A2) into something that locks the part of "A:A,A2" but changes 9FTD into 10FTD, 11FTD, 12FTD and so on.

Thank you for helping.