=COUNTA(A:A) will count non-blank cells in column A

Any non-blank cell would have a length greater than 0


Gord Dibben MS Excel MVP


On Sun, 22 Jun 2008 08:16:01 -0700, Jakobshavn Isbrae
wrote:

How can I count the number of items in a column whose length exceeds zero?