You need to find a workaround...

Here are a couple;

1.
a. On each sheet in the same cell, say A1 have your formula which counts the
"text"
=COUNTIF(C65:C75,"TEXT")
b. Then in a cell in the summary sheet use
=SUM('1:31'!A1)

or 2.
In the summary sheet enter the numbers 1-31 in A1-A31
now in B1 use this formula
=COUNTIF(INDIRECT("'"&A1&"'!C65:C75"),"TEXT")
and copy down
then use =SUM(B1:B31) to get what you want


"Jeanne" wrote:

I have a workbook with 31 sheets (for the days of the month). I need to
create a summary count of how many times a certain "text" appears in cells
C65:C75 on the sheets of that workbook. The sheets are just named with the
numbers 1-31. I know that Countif does not work across multiple sheets and I
have tried arrays and nothing works. Please help :(