View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lazzaroni
 
Posts: n/a
Default Count Non-Blank Rows

Harlan:

It'll take me some time to understand, but your array formula is exactly
what I was looking for. I can instantly apply it to arrays of any size
without having to generate a separate column for a subtotal.

Thanks to everyone for their help.

L.

"Harlan Grove" wrote:

If your range of 1s and 0s were named M, try the following array
formula.

=COUNT(1/(MMULT(M,TRANSPOSE(COLUMN(M)^0))0))