Seems this should be simple but I'm stumped. Can't we use the "mid" function with an array within a sumif?

This criteria is testing a range matching the mid text against a static cell with text.

=SUMIF(Apr12!$E$8:$H$35,MID(Apr12!E8:E35,12,6)=Query!$A$5,Apr12!$H$8:$H$35)

forum copy.xls

Copy of test file is attached.