How do I use SUMPRODUCT if one of the criteria arrays is the same as the
totals array.

I want to total all cells in column L that have a 1 in column D, as well as
a negative amount in column L

=SUMPRODUCT((D11:D60000="1")*(L11:L60000="<0")*(L1 1:L60000))

What am I doing wrong? I've never used SUMPRODUCT before, and I think I
hate it!

--
GD