View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

Correction, to align with your columns

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...


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