"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Sam,

If the 73 is always in the same row in the column after the 72, then

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

If the numbers could appear randomly throughout the row, then another
solution whould be required.

Here is such a solution

=SUMPRODUCT(--((COUNTIF(INDIRECT("B"&ROW(numbers)&":G"&ROW(numbe rs)),72)0)*
(COUNTIF(INDIRECT("B"&ROW(numbers)&":G"&ROW(number s)),73)0)))