View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default COUNTA or COUNTIF??

This is an Excel ng. Countif would be the function in Excel.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jayme" wrote in message
...
I am trying to count the # of times a name appears in a column. If I use
COUNTA, it counts the # of filled cells. COUNTIF just gives me and error
message.
I am using Office.org Calc, if that makes any difference

Please help!