Hi all,
I am using office 2010. I am calculating some data using the formula

=sumproduct(countifs(A:A,"Phone",J:J,"US",K:K,'Rough'!A1:A5))

But it is taking long time to calculate. Is there any other way to calculate..Pleaes help....

Tha Overall data range is A1 to AE10000.