How to count the total cells that contains text data?

		Microsoft Office Forums > Microsoft Excel > Excel
How to count the total cells that contains text data?

FAQ

Mark Forums Read

Thread Tools

Display Modes

06-30-2011, 01:01 PM

Learner7

Windows XP How to count the total cells that contains text data?

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

How to count the total cells that contains text data?

Hi,

I have a column called status. In that column I have text like the following:

Delivered
On Hold
Despatched
Delivered
Delivered
Delivered
On Hold
Despatched
Despatched
Despatched
Despatched
Despatched
Despatched

I want to get the followign result autimatically since the data is in some hundreds.

Delivered = 4
On Hold = 2
Despatched = 7

Thanks.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I fill the below emty cells with above cell data?	Learner7	Excel	8	06-28-2011 12:10 PM
How to combine different cells data in one cell?	Learner7	Excel	1	07-28-2010 12:07 PM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:21 PM.