Conditioanl Sum Help with Multiple Sheets in a Workbook
 

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

Conditioanl Sum Help with Multiple Sheets in a Workbook
 

Have a list of sheet names in a column of yoru summary sheet. Let's say in
cells D1 to D50

=SUMPRODUCT(COUNTIF(INDIRECT("'"&D1:D50&"'!D24")," C"))

"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

Conditioanl Sum Help with Multiple Sheets in a Workbook
 

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

Conditioanl Sum Help with Multiple Sheets in a Workbook
 

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

Conditioanl Sum Help with Multiple Sheets in a Workbook
 

Duh! Senior moment.

You're correct Ashish

I will think about something else.

Gor

On Wed, 30 Sep 2009 05:07:08 +0530, "Ashish Mathur"
wrote:

Hi,

That will not work. COUNTIF() canot accept 3D references