View Single Post
  #6   Report Post  
Sam via OfficeKB.com
 
Posts: n/a
Default

Hi Bernie,

Thank you for your time and assistance. Your formula provides the required
result.

=SUMPRODUCT((Numbers=72)*(OFFSET(Numbers,0,1)=73))

Thanks again,
Sam

--
Message posted via http://www.officekb.com