#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
This could be done using COUNTIF() formulas, but a pivot table is a better option because it will automatically generate the distinct Status list (Delivered, Despatcjed, On Hold) for you. I've attached an example.
|
|
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 |