Thread: [Solved] How to count the total cells that contains text data?
View Single Post
 
Old 06-30-2011, 04:13 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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.
Attached Files
File Type: xlsx Pivot Table Example.xlsx (12.1 KB, 13 views)
Reply With Quote