array help again

  • Thread starter Thread starter Chep
  • Start date Start date
C

Chep

Thanks for info, but what if there is 0's in the array
(s). I tried using the ISERROR but I didn't get the right
number. Also what is the "--" for in the formula below.

Chris.



One way

=SUMPRODUCT(--(A1:A10/B1:B10>10))

--

Regards,

Peo Sjoblom

message
news:[email protected]...
 
Try to stay in the same thread, you can use this array formula

=SUM(IF(B1:B10<>0,--(A1:A10/B1:B10>10)))

entered with ctrl + shift & enter

-- unary minus, will force Boolean TRUE FALSE to 1 and 0 and sum
will sum all the 1s thus counting them
 
Back
Top