Not sure exactly what you are looking for....

Perhaps you should specify which cells are to show your results and where to look for the results based on what condition or conditions.

Btw, the formula in H58 of Safety Tours & PGIs can be simplified to:

=SUMPRODUCT(($D$43:$AB$50=$C58)*($D$42:$AB$42=H$57))+SUMPRODUCT(($D$25:$AB$28=$C58)*($D$24:$AB$24=H$57))+SUMPRODUCT(($D$9:$AB$12=$C58)*($D$8:$AB$8=H$57))
copied down and across