Based upon response to an earlier question, I'm attempting to use SUMPRODUCT
to create a synopsis formula. However, when I am entering the array, the
formula box Formula Result=0 though I know there are True cells within the
range. The formula I am using is:

=SUMPRODUCT((Log!B3:B80=1997)*(Log!D3:D80=17))

where the answer should be 1. In the case of both arrays, the result set
forth to the right of the array box reads "false; false; ...".

I have tried the formula with and without the quote marks ("1997"). I even
tried it by removing all but the year from the date column. I have also
tried formatting the date column as Text rather than Date. All to no avail.

HELP!