• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to move worksheet reference dynamically in a COUNTIF formula


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:

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.


New Member
Thanks Bosco. Can you explain me what column (I$1) means? Does I1 column reflect something particular?