View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
irvine79 irvine79 is offline
external usenet poster
 
Posts: 21
Default Countif any text is present

I have a column (column B) with names and I want to create a cell that
tallies the number of names in the column.

I tried =countif(B:B,<"")

thinking that Excel would then count all cells that where not empty, and
therefore has a name. It didn't work. Please help.