Thank you very much
--
jake


"Rick Rothstein (MVP - VB)" wrote:

Or, I guess more simply (that is, one less function call), this...

=SUMPRODUCT(--(A1:A1000<""))

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
You could try this...

=SUMPRODUCT(--(LEN(A1:A1000)0))

where you would chose a top-end to the range greater than the largest row
you ever expect to use.

Rick


"Jakobshavn Isbrae" wrote in
message ...
How can I count the number of items in a column whose length exceeds
zero?
--
jake