Use sheet names in column in COUNTIF formula?

Giganews Newsgroups
Subject: Use sheet names in column in COUNTIF formula?
Posted by:  Ed from AZ (prof_ofwh…@yahoo.com)
Date: Wed, 30 Jul 2008

I have the names of my worksheets in Col A.  I want to do a COUNTIF
for all these sheets in the same range on every sheet.  Is there some
way I can incorporate the cell with the sheet name into the formula?
Something like:

Col A            Col B
Sheet1        =COUNTIF('(ValueofThisSheet!A2)'!B2:B20,"*")
Sheet2
Sheet3

And then of course copy it down the column to pick up all the sheet
names?

Ed

Replies