I am finding that with the below calculation I am finding that SUMPRODUCT is
obtaining the wrong # of items. I have a column with 12 names that are
issuing this command for each command, some of the names it works, some it
doesn't - has anyone seen this before...

=SUMPRODUCT(--('worksheet1'!AD2:AD2000="BUTTON"),--('worksheet1'!U2:U2000="LATITUDE C610"))

When I use the "FILTER" on the spreadsheet I actually get the correct # - is
there something I am doing wrong?