blackcat
New Member
Hi,
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.
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.