Originally Posted by

**roninn75**
your assistance is appreciated...

If it suits you extra column see my idea

Formula in to A5 on Summary Sheet

Code:

=COUNTIF('1'!$G:$G;$A5&B$3)+COUNTIF('2'!$G:$G;$A5&B$3)+COUNTIF('3'!$G:$G;$A5&B$3)+COUNTIF('4'!$G:$G;$A5&B$3)+COUNTIF('5'!$G:$G;$A5&B$3)+COUNTIF('6'!$G:$G;$A5&B$3)+COUNTIF('7'!$G:$G;$A5&B$3)+COUNTIF('8'!$G:$G;$A5&B$3)+COUNTIF('9'!$G:$G;$A5&B$3)+COUNTIF('10'!$G:$G;$A5&B$3)+COUNTIF('11'!$G:$G;$A5&B$3)+COUNTIF('12'!$G:$G;$A5&B$3)+COUNTIF('13'!$G:$G;$A5&B$3)+COUNTIF('14'!$G:$G;$A5&B$3)+COUNTIF('15'!$G:$G;$A5&B$3)+COUNTIF('16'!$G:$G;$A5&B$3)+COUNTIF('17'!$G:$G;$A5&B$3)+COUNTIF('18'!$G:$G;$A5&B$3)+COUNTIF('19'!$G:$G;$A5&B$3)+COUNTIF('20'!$G:$G;$A5&B$3)+COUNTIF('21'!$G:$G;$A5&B$3)+COUNTIF('22'!$G:$G;$A5&B$3)+COUNTIF('23'!$G:$G;$A5&B$3)+COUNTIF('24'!$G:$G;$A5&B$3)+COUNTIF('25'!$G:$G;$A5&B$3)+COUNTIF('26'!$G:$G;$A5&B$3)+COUNTIF('27'!$G:$G;$A5&B$3)+COUNTIF('28'!$G:$G;$A5&B$3)+COUNTIF('29'!$G:$G;$A5&B$3)+COUNTIF('30'!$G:$G;$A5&B$3)+COUNTIF('31'!$G:$G;$A5&B$3)

## Bookmarks