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))
|