Hi,
That will not work. COUNTIF() canot accept 3D references
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Summary sheet is first sheet.
Insert a new sheet to right of summary sheet......name it Start
Insert a new sheet at end of sheets.........name it End
In your summary sheet enter in a cell =COUNTIF(Start:End!D254,"C")
When adding more sheet make sure they are inserted between Start and End
sheets.
Gord Dibben MS Excel MVP
On Tue, 29 Sep 2009 12:48:01 -0700, Curtis
wrote:
Column D Row 254 contains the text "C" in all worksheets (which have
different numeric names..i.e. 1400 thru 1423)
In a summary sheet in the same workbook I need to count the number of
instances "C" occurs.
I will later use this formula to count it the value is "D" or "E"
Thanks