Don't be concerned. You will learn to love SUMPRODUCT.

=SUMPRODUCT((D11:D60000=1)*(L11:L60000<0),(L11:L60 000))

also see:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
and
http://www.mcgimpsey.com/excel/variablerate.html

--
Gary''s Student - gsnu200824


"GD" wrote:

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