Data Calculation From Multiple Sheet In Range

This is my previous problem and it work: http://www.excelforum.com/excel-form...-argument.html

However, when I try to sum the data of range A1:A5, it only show the sum on first sheet. But when I check the formula with F9 it did bring all data over. Below is the formula I use, any idea?

=SUMIF(INDIRECT("'"&'Summary'!A1:A20&"'!A1:A5"),"<1000")