First, thank you for taking the time to respond. Your formula does count
text and numbers, but also counts nulls.
--
jake


"Pete_UK" wrote:

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