Sumproduct Problem

Hello
Have you tried removing the Quotation marks from around the TRUE criteria. For example, this works for me:

=SUMPRODUCT(($A$1:$A$10=TRUE)*($B$1:$B$10="Case Control"))

Whereas:

=SUMPRODUCT(($A$1:$A$10="TRUE")*($B$1:$B$10="Case Control"))

Does not.

DBY