Based on prior input from the group, I am using the following formula:

=SUMPRODUCT(--(Log!B3:B80=1997),--(Log!E3:E80=17))

The data in Column B is actually a full date, entered yyyy/mm/dd. With the
data in this format, I get a formula result of 0. If I eliminate the /mm/dd,
I get the correct result of 1. I have tried the formula with and without
quotes around the Condition.

The person for whom I am creating this spreadsheet has asked that the date
be kept together, rather than separating out the year. Is there some way I
can maintain the data in Column B and change the formula to get the correct
result?