Hi,

You can use this formula

SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&H9:H11&"!C18:C 28"),B18))

In range H9:H11, I have 1,2,3. Please extend this range to include 1-31.
Also, I have assume that the range in which I have to count is C18:C28.
Please adjust the range

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jeanne" wrote in message
...
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 :(