With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.

Tuesday, May 22, 2012

yogi_Compute The Number Of Non-Blank Rows In Specified Columns

user NYVergara said:Is it possible to count the number of rows in a given field with only names in the cells? (no numbers) I want a total of cells which have data not empty cellsI have a spreadsheet and would like to count the number of rows used. There are several columns but not all of the rows have data. Example: Column D: I am using row 31 to 50 in Column E: I am using Row 31 to 43 can I get a total in row 51 that tells me how many rows were used in column B and how many rows were used in column E? Thanks!----------------------------------------------------------------------------------------------
following is a solution to the problem