find word in sheet

[bobaol]

Hello, i have a sheet from B1 to Z44444 that contain a lot of text in each cell. I want to find the number of times the word "freedom" exists in this range and put the count in A1. it would need to find any variation of it, like "myfreedom", "yourfreedom", etc. if the word exits in a cell more than once, i only need to count it once. any help is appreciated. thanks in advance.

 

[Cubist]

This should count the number of occurrence of "freedom" in the range.

=COUNTIF(B1:Z44444,"*"&"freedom"&"*")

 

[dreid1011]

Maybe this:

Book1
	A	B	C	D
1	15	yes	no yes	no
2		yesno	yes	maybe
3		yes	noyes	yes no no
4		yes	no	yes
5		yes	no	yesyesno
6		no	no	no
7		no	no yes no	no
8		yes	yes yes	no
9		no	no no	yes
Sheet4

Cell Formulas
Range	Formula
A1	A1	=COUNTIF(B1:D9,"*yes*")