( by ZackC )
I have a spreadsheet that needs quite a few Query calls,176 and more all the time.
Note you have used ImportRange and Vlookup many times, which can be reduced to just one time... And Query formula can be replaced with Sumif and Arrayformula..
In above sheet, I have the following formula in Cell A1:
=query(ImportRange("0AjFhwhh41YUwdE9UV216bkFBcVZoR3h3djZfSnQ5Z1E", "Inventory!A:T");"select Col15,Col1,Col2,Col16 where Col1<>'' ")
and the following formula in Cell E1:
=arrayformula(if(row(A:A)=1;"Count from Input";if(A:A="";"";sumif('Import'!C:C;B:B;'Import'!E:E))))
Have a look at the following screenshot of Spreadsheet "Inventory - Purchase Orders" Sheet "Import":
So now you will have very less number of formulas in your spreadsheet, which is going to reduce spreadsheet complexity and increase the performance and loading speed.
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.