I can't seem to get the SMALL function to work for me the same way the
LARGE function does.

Say I have a table of two columns with the data in the first column
A1:A6 (range called TABLE) being se****ial numbers 1 thru 6 and a
second column B1:B6 (range called TARGET) with B1:B3 each = 1 and
cells B4:B6 each = 0.

When I put the following formula in C1 as an array formula

{=SUM(LARGE((TARGET=1)*TABLE,ROW(INDIRECT("1:2"))) )}

It gives me the right answer, or at least what I expected it to give
me, the value of 5. It sums the two largest numbers in the range
TABLE that first met the criteria set out for the range TARGET.

However, when I use the exact same formula, but substitute the LARGE
function for SMALL, it gives me a value of 0. I thought it should
give me a value of 3 (which is the sum of the two smallest numbers
that meet my criteria).

{=SUM(SMALL((TARGET=1)*TABLE,ROW(INDIRECT("1:2"))) )}

What is wrong?