Can't you use SUMIFS?

e.g

=SUMIFS($AO$5:$AO$1000,$Q$5:$Q$1000,">="&G5,$Q$5:$Q$1000,"<"&G6)

or am I missing something?