AppleWorks Spreadsheet help?
September 1, 2004 6:25 AM   Subscribe

AppleWorks Spreadsheet: how do I write a formula which returns a count of the number of times a specific string of text occurs in a cell range?
posted by Dick Paris to Computers & Internet (3 answers total)
 
Do these help?

Funtions guide

Intro to AW Spreadsheet

I just glanced at the functions guide - try setting up a secondary cell-range that reports a 1 or 0 for the string you are after and running the numeric count against that range.

Good luck!
posted by mwhybark at 6:52 AM on September 1, 2004


I'll give those a look Mwhybark, although my look into the help files and googling left me wanting. Maybe I am just not understanding what I am reading. :-|
posted by Dick Paris at 6:56 AM on September 1, 2004


Have it working now, Mwhy. Thanks. Somehow I was reading that the "COUNT2" function could select a partial string of text from a cell. Not so. :-)
posted by Dick Paris at 12:03 PM on September 1, 2004


« Older Describe this scenario   |   Hiking with blisters suggestions? Newer »
This thread is closed to new comments.