Try...

=SUMPRODUCT(--(D5:D12100),--(D5:D12<900),G5:G12)

and

=SUMIF(D5:D12,"<900",G5:G12)

Hope this helps!

In article ,
C Glenn wrote:

I can't get this to work. In every case, the first criteria is applied
and the second is ignored.

Put these numbers in D, starting at D5:

45
123
789
4156
123
456
987
321


Now put these in G, starting at G5:

65
32
8546
123
646
564
6
54

If you put the following in G13:
=SUMIF(D5:D12, {"<900","100"},G5:G12)
it will return the same result as
=SUMIF(D5:D12, {"<900"},G5:G12).

The result of the first formula should be 65 less than the second.