Text Count

[petenorriss]

Hi all

Stupid question I know but I have a list of words in colum A and I want to do a count of certain words. How do I do this.

 

[Brian from Maui]

Hi all

Stupid question I know but I have a list of words in colum A and I want to do a count of certain words. How do I do this.

=COUNTIF(RANGE,"WORD")

 

[petenorriss]

Spot on mate.

Just one more thing, how do I use a the count function on ranges. Ie i have a list of ages and I want to count those between 40 and 50, 51 and 60 etc

 

[Brian from Maui]

Spot on mate.

Just one more thing, how do I use a the count function on ranges. Ie i have a list of ages and I want to count those between 40 and 50, 51 and 60 etc

A couple of options,

=COUNTIF($A$1:$A$100,">=40")-COUNTIF($A$1:$A$100,">50")

=SUMPRODUCT(--($A$1:$A$100>=40),--($A$1:$A$100<=50))