Help needed with Multiple Criteria

Merged cells are a bad idea for several reasons and should be avoided. Unmerge and fill the same data into all the unmerged cells and then use conditional formatting to hide them using the same font colour as the background for Service and Product, then do a AVERAGEIFS formula.

Here you go:

The formula used is and array one:
=INDEX($B$5:$M$8,MATCH(A13,$A$5:$A$8,0),MATCH(1,IF($B$2:$M$2=B13,IF($B$3:$M$3=C13,IF($B$3:$M$3=D13,,1))),0))

I've modified the template as I said in my previous post.

this formula should work for you BUT it depends on a couple things.
1) you get rid of the merged cells, so for example take the SVR and instead of merging it across cells B2:G2 put it in EACH cell, same with EXD.
2) repeat for DOC and PKG, put them in each cell from B3 through M3
3) make the zones match between those in your references in cells D13 through D16, you have ZONE-1 there but above you have some of the Zones with spaces so they do not match such as Zone -1 in cell B4.
Once you make those changes, this formula should return what you want...
=SUMPRODUCT(($B$5:$M$8)*($A$5:$A$8=$A13)*($B$2:$M$2=$B13)*($B$3:$M$3=$C13)*($B$4:$M$4=$D13))

You're welcome AND thank you for the rep!