• 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

    Hui...

  • 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

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.
 
Thanks Bosco. Can you explain me what column (I$1) means? Does I1 column reflect something particular?
 
Back
Top