|
|
#2
06-30-2011, 04:13 PM
|
||||
|
||||
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode