Sumproct, sumif indirect formula long run time.

I am not aware that were is a right process or not. Forum Moderator : Please allow this post if this is not right process. Or please let us know what is a process.
Or it may be duplicate post. I have search lot of on my issue but our problem not located.

Recently i have posted below thread & my problem solved. But after working on below formula i would notice that, the below formula run very slow. Because our sheets as well as data record is very large.

http://www.excelforum.com/excel-gene...-criteria.html

My formula is as below.
=SUMPRODUCT(SUMIFS(INDIRECT("'"&LIST&"'!$D:$D"),INDIRECT("'"&LIST&"'!$C:$C"),$A15,INDIRECT("'"&LIST&"'!$I:$I"),F$2))

In view of the above please let us know how to calculate faster. Because I have 6 to 7 sheets with huge data record. I don't want to use with sumproduct formula and also vba micro because I am not familiar with VBA.

Dear Dilip Pandey,
Thanks. I would like to inform you our laptop is brand new one & config. is Intel(R0 Core(TM), i3-2330 M cpu, @2.20 GHz, 790 MHz, 4GB RAM. Now up-gradation not possible for me.

Yes exiting formula works perfectly but its run time is very long. I require some other formula instead of above, with using only sumif indirect with two or three criteria.