View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How to sum ONLY text?

Yes. COUNTA()
Thanks for pointing that out...

"Luke M" wrote:

Jacob, I think you meant COUNTA(), as COUNT does not recognize text.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jacob Skaria" wrote:

If you mean count the names use the COUNT() function

If this post helps click Yes
---------------
Jacob Skaria


"ExhalE" wrote:

Hi.

I've got a worksheet here with alot of names, timetable. How do i sum names
without the value coming out as "0" ?