View Single Post
  #3   Report Post  
don
 
Posts: n/a
Default

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