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

Hi Bob,

Please ignore my previous reply to you. All is clear now.

Missed your link to Bernie's Post -

"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(numbe rs)),73)0)))

Thanks
Sam

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