Excel 2007 : Calculating average and total for ranges within a list

If you insert a column in the summary table and create a start column and separate end column

so 0 in one column and 199 in next column and so on, then try

=IFERROR(AVERAGEIFS($D$3:$D$35,$B$3:$B$35,">"&B40,$B$3:$B$35,"<="&C40),0)

AND

=SUMIFS($E$3:$E$35,$B$3:$B$35,">"&B40,$B$3:$B$35,"<="&C40)


assuming B3:B35 are the Sales figures you want to check