Posted to microsoft.public.excel.worksheet.functions

Mike G

external usenet poster

Posts: 26

Counting # of occurances of words in text

If I have a cell that contains "good things come in good packages" and want
to count the number of occurances of the word "good" how would I do that?
Have tried countif and sumproduct and both give me #name?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting 7 and 8 occurances	[email protected]	Excel Discussion (Misc queries)	2	May 9th 07 02:59 AM
Counting occurances	LauriS	Excel Discussion (Misc queries)	8	March 29th 07 07:34 PM
Counting Occurances	Rusty	Excel Discussion (Misc queries)	5	July 10th 06 08:29 PM
counting text example of a cell with multiple words inside	steveo	Excel Discussion (Misc queries)	1	June 6th 06 04:47 AM
counting text example of a cell with multiple words inside	steveo	Excel Discussion (Misc queries)	0	June 6th 06 03:30 AM

All times are GMT +1. The time now is 11:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us