Hi Bob,
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)))
Also these array formulas (not dependent on any location) :
=SUM(--(0<MMULT(--(Numbers=72),TRANSPOSE(COLUMN(Numbers)*0+1))
*MMULT(--(Numbers=73),TRANSPOSE(COLUMN(Numbers)*0+1))))
or
=COUNT(IF(MMULT(--(Numbers=72),TRANSPOSE(COLUMN(Numbers)^0)),
1/MMULT(--(Numbers=73),TRANSPOSE(COLUMN(Numbers)^0))))
Regards,
Daniel M.
|