Thread: Countif
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Countif

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