Thread: [Solved] How to count the total cells that contains text data?
View Single Post
 
Old 06-30-2011, 01:01 PM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default 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.
Reply With Quote