Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Count Cells With Specific Text in Excel

While working on a client’s sales plan last week, I had to count the orders for a couple of specific customers.  Here’s a screenshot of some sample data, with the customer names in column B.

Count cells that are an exact match
In Excel, you can use the COUNTIF function to count cells that meet a [...]