View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default How to sum ONLY text?

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" ?