Hi,
I got a spreadsheet that was created about 1 year ago and notice it uses a lot of arrays.
={Sum(O6:O156:AB6:AB156) + AM$7$}
When it could use
=Sumproduct(O6:O156,AB6:AB156) + AM$7$
Other then being confusing and less transparent, are arrays slower then sumproduct in this example above? I noticed the spreadsheet extremely slow.
Thanks
I got a spreadsheet that was created about 1 year ago and notice it uses a lot of arrays.
={Sum(O6:O156:AB6:AB156) + AM$7$}
When it could use
=Sumproduct(O6:O156,AB6:AB156) + AM$7$
Other then being confusing and less transparent, are arrays slower then sumproduct in this example above? I noticed the spreadsheet extremely slow.
Thanks