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

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 »

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 08:16 AM.