Hi!

If you use the default sheet names: Sheet1, Sheet2,=20
Sheet3, etc ....

Assume you want to Countif B1:B10 equals 10 on sheets 2:10

=3DSUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIREC T("2:10"))
&"!B1:B10"),10))

If you use custom sheet names ....

List the sheet names in a range, say H1:H9

=3DSUMPRODUCT(COUNTIF(INDIRECT(H1:H9&"!B1:B10"),10 ))

Biff

-----Original Message-----
Sorry in advance for what is likely a very basic=20
question, but I would=20
appreciate help. I have created a workbook with multiple=20
worksheets which=20
all have the same format, but different data. For=20
example, each row=20
represents a person, and each column represents a time=20
period. The row and=20
column headers are the same in each worksheet, but what=20
HAPPENED in the time=20
periods varies. I=E2?Tm trying to create a formula that=20
would look at the SAME=20
range in each worksheet and count how many times a=20
specific variable appears,=20
returning simply the number of occurrences. It would=20
seem to be a COUNTIF=20
formula, but that function doesn=E2?Tt seem to like 3-D=20
references.

Any ideas?????
.