Hi All,

Maybe this is an old topic on the multi condition. I found that we all almost use SumProduct for multi-condition matter.

I just wander whether we have any other way to solve the multi conditions? as sumproduct is really use a huge resource. Everytime I open the sheet which is full of sumproduct, it take 1 minutes to recalculate.

I heard somewhere on array function. Do you know how to use it?

Thansk in advance.