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?
Response by poster: 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
posted by Dick Paris at 6:56 AM on September 1, 2004
Response by poster: 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
posted by Dick Paris at 12:03 PM on September 1, 2004
This thread is closed to new comments.
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