SumProduct

[seals]

Hi All,

I am looking for a better way to enter the following code into VB.

=SUMPRODUCT((ORB!K10:K900=2)*(ORB!Y10:Y900="X")*(RIGHT(ORB!O10:O900,3)="ARM"))

At present although it works it, is extremely slow

Does anyone have any ideas? I need it to return the value to a shee
named KPI and the cell reference of B10.

Any help in the right direction would be appreciated, as I have a
present, run out of ideas.

Thankyou in advance,

Mark :

 

[Frank Kabel]

Hi
VBA would probably be even slower. This formula alone
should be no performance issue but I assume you have
several of this kind of formulas.
You may consider using a pivot table for this (but this
depens on your reporting requirements)