SUMPRODUCT: * vs --
http://tinyurl.com/2norxe
I found the timings at this link
http://img46.imageshack.us/img46/4064/calctimesax7.jpg
interesting. But what are the time measurements in... seconds? Assuming
so, should one really be overly concerned about a process that takes a
little over a hundredth of a second as compared to one taking about
three-quarters of a hundredth of a second? I doubt too many users would be
able to perceive a real-world delay of an extra three or four thousandth
of a second.
In re-reading my posting, I think if may sound more confrontational
(arrogant?) than I meant it too... I was just wondering aloud if the timing
difference is really something that should be of concern in a real-world
application. One process could be twice (even three, four, or more times) as
fast as another and yet, in real-world terms, be of no significance
what-so-ever. I think this issue may be just such a situation.
Rick