To Array or not to Array...

  • Thread starter Thread starter hmm
  • Start date Start date
H

hmm

....That is the question!

Is there a difference (in terms of processing speed, efficiency, etc.)
between using the non-array SUMPRODUCT formula or using the SUM array
formula? When used on a large scale, is one faster - or better in some
way - than the other?

thanks.
 
Hi ""
In my limited experience I find that on large worksheets,
array formulas are far more processing greedy than SUMPRODUCT
and hence take longer.
I tend to prefer arrays though! And i find more user friendly with
nested IFs (with SUM/COUNT etc)
Mathew
....That is the question!

Is there a difference (in terms of processing speed, efficiency, etc.)
between using the non-array SUMPRODUCT formula or using the SUM array
formula? When used on a large scale, is one faster - or better in some
way - than the other?

thanks.
 
Back
Top