Home » Forums » Open Source Learning Center » Question and Answer

Gather data from multiple tabs of the same work book.

Submitted by DRT1968 on 12 January, 2016 - 16:44

I have about 30 tabs of data. How could I get a count of a certain code used in a certain column. I use general codes "WP","R", in column C some tabs have one row of data some have 10. Just want a consolidation page to total up the amount of each code I use. Thanks for you help.

‹ Help needed! IF, SUMIFS, INDEX-MATCH or anything else??? Help with a sheet to compare health insurance plans for consumers ›
»

Simple but messy

Submitted by mec1981 on 14 January, 2016 - 06:07.

Use Countif? if you have these codes in column C say just use the following but expand to include relevant tabs:

=sum(countif(Sheet2!C:C,"WP"),countif(Sheet3!C:C,"WP"),countif(Sheet4!C:C,"WP"))

Regards
Mark

»