Your array formula is written as an "or" conditional test.

J46:J522<L4 OR J46:J522L3

The formula I suggested is written as an "and" conditional test:

J46:J522L3 AND J46:J522<L4

The formula that you got to work is essentially the same as the "or" version
but it's spread across two separate functions.

This one will do the same thing:

=SUMPRODUCT(--(J46:J522<""),--((J46:J522<L4)+(J46:J522L3)0))

--
Biff
Microsoft Excel MVP


"Robert" wrote in message
...
Interestingly, this one DOES work:

=SUMPRODUCT(--(J46:J522<""),--(J46:J522<L4))+SUMPRODUCT(--(J46:J522<""),--(J46:J522L3))