">=H2" will treat H2 as a text string rather than a cell reference

=AVERAGEIFS(C1:C100,B1:B100,">="&H2,B1:B100,"<="&I2)