Try using COUNTIF, i.e.:

=COUNTIF(A:A,"<")

will count everything in column A which is not blank (or appears to be
blank, like a formula returning "")

Hope this helps.

Pete

On Jun 22, 4:16*pm, Jakobshavn Isbrae
wrote:
How can I count the number of items in a column whose length exceeds zero?
--
jake