Thread
:
Count and Sum Total occurrances of two specific numbers
View Single Post
#
9
Sam via OfficeKB.com
Posts: n/a
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
Reply With Quote