View Single Post
  #9   Report Post  
Daniel.M
 
Posts: n/a
Default

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.