You need INDIRECT:
=COUNTIF(INDIRECT("'"&C1&"'!M:M"),B2)
You need INDIRECT:
=COUNTIF(INDIRECT("'"&C1&"'!M:M"),B2)
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks