B
Big John
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.
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.