Hi,

Most Excel functions don't handle 3-D references, so your best solution
would probably be, in cell B1:

=COUNTIF(Sheet2!B$1:$C$100,C1)+COUNTIF(Sheet3!B$1: $C$100,C1)+COUNTIF(Sheet3!B$1:$C$100,$C1)

Where C1 is something like TextA. The way I've written it you can copy it
down and over to the left and it will do all of your work.

If this helps please, please click the Yes button

Cheers,
Shane Devenshire

"Big John" wrote:

I have a workbook with 10 different worksheets. Each worksheet has 3 columns
of data with varying number of rows.

Example:

Worksheet 1
Col A Col B Col C
1 3 TextA
7 0 TextB
1 0 TextE

Worksheet 2
Col A Col B Col C
1 0 TextA
1 0 TextB
7 1 TextC
2 2 TextE
1 0 TextF

Worksheet 3
Col A Col B Col C
3 2 TextG
5 5 TextN

etc...

Columns A and B are counts of the description in Column C.

Column C will only be present if there is a positive value in Col A.

I want to have a summary sheet that will have sum of the counts in Column A
and Column B that correspond with the definition in Column C

Summary
Col A Col B Col C
2 3 TextA
8 0 TextB
7 1 TextC
3 2 TextE
1 0 TextF
3 2 TextG
5 5 TextN

I believe I need to use a LOOKUP function, but have been unsuccessful. I
can change the output so Column C is actually the first column and then have
the counts follow (figuring that may help me use the VLOOKUP function).

I've put all of the worksheet names in cells and tried referencing them by
name (also like the trick I read where you have a Start and End worksheet and
hide them) as to be able to easily reference all the sheets, but I think I'm
making things too difficult.

Any help/guidance would be greatly appreciated.