I feel sure that I've done this but don't recall how as it has been a while.

I have a column of text entries, how do I count the number of cells that are blank and how many have entries? In one column, all the text entries are the same but in other columns there are a wide variety of different texts. All I need is that there are, for example, 27 blank and 126 that have text in them. I don't need the contents, just the number that have contents.

OO 3.1 & LibreOffice 3.3.1/XP SP3

thanks,

Allen
--
------------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: sy...@openoffice.org with Subject: help

Reply via email to