Hi, I have 20000 array formulas in an excel sheet. {=SUM(IF(C4:C25000=C4,IF(E4:E25000=E4,AA4:AA25000, ""), ""))}

I am using vba to refesh the columns. Range("A:C").calculate

This takes 8 mins to calculate them. Is there an easy way to either enter and calculate the formula through vba or calculate it through vba which is much quicker?