Sumproduct takes too long
 

Dear all, I have the following macro and have tried a few things to make it run quicker but it still takes too long. the below code only runs on one column but i have 40 such columns. so all in all macro takes about 30 mins to run. Any idea how i can make it faster or other ways of achieving...