Text Count

petenorriss

New Member
Joined
Nov 30, 2004
Messages
33
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.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
petenorriss said:
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

New Member
Joined
Nov 30, 2004
Messages
33
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

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
petenorriss said:
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))
 

Forum statistics

Threads
1,148,055
Messages
5,744,544
Members
423,882
Latest member
Seeham

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top