Bob Phillips Wrote:
I don't think this thread is worth continuing.
[...]
I suggest that a generic answer to everyone is to ignore this post,
and
understand that there are appropriate times to use SUMIF/COUNTIF,
appropriate times to use array formulae, appropriate times to use
VLOOKUP,
and appropriate times to use SUMPRODUCT. There is no universal theory
of
everything in Excel formulae :-).
[...]

Au contraire. Pierre Leclerc, for all we know, might believe what he
states. There are lots of spreadsheet users who end up thinking the
same, seeing 'thousends of Sumproduct or array formulas' offered by us
here and elsewhere. More often than not without concern for efficiency
and robustness. Leclerc's post is an excellent occasion to re-consider
such matters.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=319150