=SUMIFS($H$6:$S$148, $F$6:$F$148, $H$2, $H$5:$S$5, $H$1)
Actually ignore that, it won't work. Ranges are not the same shape.If that is what you need here is an alternative. Not necessarily better.
Excel Formula:=SUMIFS($H$6:$S$148, $F$6:$F$148, $H$2, $H$5:$S$5, $H$1)
Slight modification:Actually ignore that, it won't work. Ranges are not the same shape.
=SUMIFS(INDEX($H$6:$S$148,0,MATCH($H$1,$H$5:$S$5,0)), $F$6:$F$148,$H$2)
Many Thanks for your time and your helpSlight modification:
(Index returns a range not an array so should work on pre 365)
Excel Formula:=SUMIFS(INDEX($H$6:$S$148,0,MATCH($H$1,$H$5:$S$5,0)), $F$6:$F$148,$H$2)