Doesn't work as intended?

Here an example use of the formula system:

http://www.mrexcel.com/board2/viewtopic.php?t=146895

rhani111 wrote:
ok.....ummm I am more confused than ever with your reply...I have no
idea what all that meant at all...lol

can you please explain??



--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.