On Wed, 2006-01-18 at 17:31 -0800, Dennis Marks wrote: > Is there a function or a simple formula that will count the number of times > a specific character is on a spreadsheet. I have many noncontiguous cells > on a spreadsheet. I want to know how many have an "X" in them. Other cells > will never contain an "X" so the entire sheet could be searched if > necessary. Something like =countcharacter(A1:Z99;"X") would be nice.
Hi Dennis, Does the COUNTIF() function work for you here? Try =COUNTIF(A1:Z99;"X") Regards Jonathon -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]