Hello all

Does anyone have a way to reduce the multiple COUNTIF function in the following to use one COUNTIF to encompass all ranges please?

=COUNTIF('Panel Draw'!B11:T40,"H1")+COUNTIF('Panel Draw'!B58:T87,"H1")+COUNTIF('Panel Draw'!B105:T134,"H1")+COUNTIF('Panel Draw'!B145:T174,"H1")+COUNTIF('Panel Draw'!B185:T223,"H1")

I need to use the statement addressing different cell ranges about 200 times in a Workbook.

Tanks