Hi Aladin

could you please provide an example of what you mean by
"..... one should try to reduce 2 or more conditions to a single condition
by concatenating them ...."

Cheers
JulieD

"Aladin Akyurek" wrote in
message ...

Pierre Leclerc Wrote:
...

When you discover the SUMPRODUCT formula, you can forget about COUNTIF
and SUMIF.

...

That's non-sense. Whenever a single condition involved, one should
invoke CountIf for counting and SumIf for summing. Moreover, if
efficiency (speed) is a concern, one should try to reduce 2 or more
conditions to a single condition by concatenating them and invoke a
CountIf or SumIf formula or a SumProduct or an array formula using
Count or Sum with a lesser number of conditionals.

Also when you discover INDEX/MATCH you can replace VLOOKUP, HLOOKUP
and LOOKUP.
...

The generality of INDEX/MATCH is no reason to dispense with VLOOKUP and
HLOOKUP. And there are classes of lookup problems Index/Match cannot
solve, but LOOKUP can.


--
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