Using SUMPRODUCT
 

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!

Hi

If I understand this right:
1997 has nothing to do with a date (unless the date is june 19 1905). 1997
has to do with the YEAR of a date.

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

HTH. Best wishes Harald

"Helen McClaine" <Helen skrev i melding
...
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!