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