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))
|