Try this, with value in J1, and < value in J2:

=SUMPRODUCT((J4:J1058J1)*(J4:J1058<J2))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"don" wrote in message
...
thanks Peo,
Can you expand this so the 40 portion is in a cell and can be
easily changed?
I tried a couple of versions and referring to a cell didn't seem to
work.

Thanks
Don


On Wed, 4 May 2005 20:36:21 -0700, "Peo Sjoblom"
wrote:

=SUMPRODUCT(--(J4:J105840),--(J4:J1058<50))