Wow. Just Wow...

xld, can you explain to me some of the details of this? I understand the whole true=1 and false=0. I am fine with that.

But, what are these cell references ? I have seen $B$1 before (absolute ref).

But what is this: Y!$1:$3 ? ---->sheet "Y"--->?--->?

EDIT: Got it I think. Rows 1 - 3.