View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Countif any text is present

You need COUNTA
--
Gary's Student


"irvine79" wrote:

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.