Pls help me on a formula as how to count how many rows which contain words in one column. For examle: column A, row a1: abc, row a2:def, row a3:ghi, row a4:no words(blank), row a5: jkl. If I use a mouse drag from a1-a5, and click on count function at the bar, it shows 4. However, I wanna use a formua to count it.Please advise. Thanks