Summing Array Formula

I have a tricky question. I want to be able to pull select values from a column based on a separate date column, and then sum those values. I'm using an array with the formula:

=IF(ISERROR(INDEX($AO$5:$AO$1000,SMALL(IF(($Q$5:$Q$1000>=G5)*($Q$5:$Q$1000<G6),ROW($AO$5:$AO$1000)),ROW(5:5)),2)),0,INDEX($AO$5:$AO$1000,SMALL(IF(($Q$5:$Q$1000>=G5)*($Q$5:$Q$1000<G6),ROW($AO$5:$AO$100)),ROW(5:5)),2))

In order to sum the values the only way I know how to do it right now is by manually adding the next row like

=IF(ISERROR(INDEX($AO$5:$AO$1000,SMALL(IF(($Q$5:$Q$1000>=G5)*($Q$5:$Q$1000<G6),ROW($AO$5:$AO$1000)),ROW(5:5)),2)),0,INDEX($AO$5:$AO$1000,SMALL(IF(($Q$5:$Q$1000>=G5)*($Q$5:$Q$1000<G6),ROW($AO$5:$AO$100)),ROW(5:5)),2)) + IF(ISERROR(INDEX($AO$5:$AO$1000,SMALL(IF(($Q$5:$Q$1000>=G5)*($Q$5:$Q$1000<G6),ROW($AO$5:$AO$1000)),ROW(6:6)),2)),0,INDEX($AO$5:$AO$1000,SMALL(IF(($Q$5:$Q$1000>=G5)*($Q$5:$Q$1000<G6),ROW($AO$5:$AO$100)),ROW(6:6)),2))

You can see that I have a large range of data, almost 1000 lines. Manual entry for that range is too much, so how can I set up the array sum automatically?

Am I missing something? Why not just sum all of those result cells?

The thing was I didn't want to have results cells, over the range of 1000 cells I would would need 1000 columns of results. I didn't realize that SUMIFS would let me return values from different column than the test criteria. That does seem to do the trick. I can probably mark this as complete, except i'm still curious as to whether or not there is a way to do it with an array formula.